Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    223

    Unanswered: Datetime conversion

    Hello, everyone:

    How to convert '173515' to be datetime like "5:33:00 PM". Thanks.

    ZYT

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I can guess that 5 pm comes from 17 mod 12. But how do you get 33 minutes and 00 seconds out of your sample string?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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