var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Problem converting UTC dates in dts
Can anyone help me convert UTC dates in a dts package? I have a db I need to transform, but all the dates are in utc format. Is there a function I can use in an ActiveX transformation script to convert, say, 38166, to a valid datetime value? There seems to be almost no documentation in using utc in SQL.
I'll try...but for the record i dont think 38166 is a valid UTC date.
Please correct me if i'm wrong.
here is what i thougght UTC date looked like:
SQL server CAST and CONVERT will handle this for you, by default.
But your example does somewhat resemble a Julian date....
Originally Posted by
But yeah it looks more julian..
My vote is for 2008, since the Unix epoch is based on 1970.
I'll go with thta...(since I wrote a udf for that one once)....god damn toolbox...got to clean this damn thing out....
Wait a minute....
i bet there'll be a party or 2 ~3:15 on Jan 19 2038
the end of the world as we know it.
you've got a julian date converting UDF?
Oooooo...i've wanted to do that but never had a project that required it.
Care to share????
I wrote one ages ago for military style Julian dates, and just posted it a day or two ago. Check
here for details.
sorry for the thread hijack chunky,
did you get a decent answer for the original post?
perhaps you could post an example of the date string you are dealing with, if not?