469,332 Members | 6,612 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,332 developers. It's quick & easy.

Converting C++ Unix time_t Julian date to SQL date


I've just been trying to do this. I looked on Google and it seems to
be a common problem with no obvious solution. I've seen various
solutions which don't seem exactly elegant, so I figured I'd post the
solution I came up with. It's effectively a single line solution,
albeit with various embedded calls. It makes an adjustment for the
local timezone too!
DECLARE @time_t INT
SET @time_t = 1090834321 /* 10:32am, July 26th 2004 BST */

DECLARE @timestamp DATETIME
SET @timestamp = dateadd (ss, datediff (ss, GetUTCDate(), GetDate()),
dateadd (ss, @time_t, '19700101'))
PRINT @timestamp
Hope that helps. If there's a problem with it, let me know!

andyt

Jul 20 '05 #1
0 1701

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Dan Jacobson | last post: by
5 posts views Thread by francescomoi | last post: by
7 posts views Thread by bob | last post: by
3 posts views Thread by Jef Driesen | last post: by
5 posts views Thread by Grey Alien | last post: by
11 posts views Thread by Keith Hughitt | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Marylou17 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.