October 16, 2014 at 5:58 am
In VBA, CLng(Now) will return the integer portion of a date CLng(Now) returns 41928, CDate(41928) then returns 10/16/2014. Is there something equivalent in SQL Server that will allow me to convert an integer value to a date?
In short, how can I convert a 100 year date to Gregorian (any format)?
October 16, 2014 at 6:15 am
david.holley (10/16/2014)
In VBA, CLng(Now) will return the integer portion of a date CLng(Now) returns 41928, CDate(41928) then returns 10/16/2014. Is there something equivalent in SQL Server that will allow me to convert an integer value to a date?In short, how can I convert a 100 year date to Gregorian (any format)?
There's more context to this question in the near-duplicate post in the Tally Table discussion at http://www.sqlservercentral.com/Forums/Topic496042-203-43.aspx. I'm going to post my reply there.
October 16, 2014 at 6:19 am
Thanks. I wasn't certain about if I should post it in both or not.
October 16, 2014 at 6:46 am
david.holley (10/16/2014)
Thanks. I wasn't certain about if I should post it in both or not.
Many of the regular posters view the most recent posts by date, so we'll see it.
I posted a solution in the other thread that I hope helps you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply