User Profile

Collapse

Profile Sidebar

Collapse
bedlam
bedlam
Last Activity: Apr 22 '10, 07:00 PM
Joined: Apr 21 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • bedlam
    replied to Date conversion problem
    in SQL Server
    Figured it out. The stored integer 2440588 does represent the date 01/01/1970, if you use the Julian date (JDN actually) for the number of days since Jan 1, 4713 BC...yep...BC.

    Thanks for the reply.
    See more | Go to post

      Leave a comment:

    • bedlam
      started a topic Date conversion problem
      in SQL Server

      Date conversion problem

      I have a date stored in an INT column of 2440588
      This is supposed to be the date of 01/01/1970.
      I can not find any way to convert the 2440588 value to a MM/DD/YYYY format, no matter what I try. Maybe I need another set of eyes.
      Anyone able to help?

      Thanks
      TK
      See more | Go to post
      No activity results to display
      Show More
      Working...