Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    144

    Unanswered: Function or SP for date conversion

    i have a field that date stored in it, format of this date is somethin like timestamp. for example today(9Nov2005) saved as 38665.
    how can i convert this value to a normal date format?
    any function or sp?

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by bono56
    i have a field that date stored in it, format of this date is somethin like timestamp. for example today(9Nov2005) saved as 38665.
    how can i convert this value to a normal date format?
    any function or sp?

    SELECT CAST ( 38665 as datetime)
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •