Hey since there are a few dorks here... In SQL (Microsoft) is there a quick function that will convert a Julian Date to a standard mm/dd/ccyy date format?
...an army of one (gear).
|
...an army of one (gear).
|
|
GEEK HELP...Hey since there are a few dorks here... In SQL (Microsoft) is there a quick function that will convert a Julian Date to a standard mm/dd/ccyy date format? |
User loginActive forum topicsRandom Image
Newest Album
AdvertisementsPay Up!It's only $15 a year for some extra features! Every little bit helps keep this site up and running so click here for the details. Weather There are currently 6 users and 2 guests online.
Online users
Recent Visitors47 here in the last 24 hours
69 here in the last week |
all trademarks and copyrights on this page are owned by their respective owners. comments/images are owned by the poster.
Or does anyone have a quick
Or does anyone have a quick script to do it?
OK to answer my own
OK to answer my own question...
I'll code this into a Stored Proc.. then pass the year and julian day as a variable...
DECLARE @julianDay char(3)
DECLARE @julianyear char(4)
DECLARE @JulianDate Char(8)
declare @dt datetime
SELECT @julianDay='031'
SELECT @JulianYear = '2008'
SELECT @JulianDate = @JulianYear+'.'+@JulianDay
SELECT @JulianDate
select @dt=DATEADD(dd,convert(int,right(@julianDate,3)) -1,
convert(datetime,substring(@julianDate,1,4)+'0101',212))
select @dt
In MySQL there is
In MySQL there is date_format:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#func...
edit: real dorks don't use MSSQL ;)
Um.
Whomp!
edit: real dorks don't use
edit: real dorks don't use MSSQL ;)
Is this because its not open source or because its MS..
neither in particular
neither in particular really.
1. I don't have anything against MS really (see http://ckdake.com/node/197 and http://ckdake.com/node/198) but don't choose to use their products because they don't work the best for what I need to do and aren't cost effective for me.
2. open source is generally nice, but it's an ease of use thing and whatever tool works best for something is the one people should use.
I should have just said no real dorks I know use MSSQL?
I'm slowly discovering
That corporate dorks use EVERYTHING micro$oft, including SQL... at least some. The big dawgs at the office however seem to prefer Oracle.
"nobody gets fired for
"nobody gets fired for buying IBM"
And corp people love them some MS Outlook. thats fo sho.
Hey I downloaded and
Hey I downloaded and installed mySQL on a slackware distro last night. I finished up the initial configuration stuff then I was tired from a long ride.
Anyway.. corp dorks. I work for a (non-Atlanta based) big bank. We also handle all the credit cards for another big bank in town. One of their issues is that we cannot use any hardware/software from a non-US based company. It took an act of congress to get licenses to use Adobe since they are a British company!
while there's an open thread for geeks...
My cool friend cool james is starting his own personal chef business and asked me to put together a basic website for him, and i haven't had much work to do this week, so i put this together:
http://www.ambrosialatlanta.com
It looks great in firefox, but the pics in the side panel on the "menu" page look like shit in IE... and I can't figure out why. I know it's something with the css but I don't know too much about that so i'm stumped. I've tried everything i can dig up on a couple of forums with no luck. A tall cold beer goes to the geek who can help a brother out.
Also if anybody notices it looks shitty in Safari as well, let me know. kthxbye.
You're using html to resize
You're using html to resize images. Reasons not to do this:
*It kills kittens
*It sucks for people with dial-up
*Apparently it also makes your page break in IE
Noted - I'm on it...
but the images appear resized in IE to the proper size, they're just formatted all stupid in regards to the sidebox they're in. That's why i think it's something with the css
fwiw
looks fine in Safari too.
solution!
If anybody cares... it was the align=right in the img tag of the html, NOT the css that was the problem. IE didn't like me trying to align the img within a sidebar with a fixed width that's smaller that the width of the image... but firefox and safari don't care i guess. Education is Fun!
Also Good call on the image resizing Tex, pages loads much faster now, thanx!