Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011

    Unanswered: time not properly setting for '05:30:00'

    I use the query in the Sybase

    select cast('05:30:00' as time)

    i am getting an out put, which is some thing different.
    "1900/01/01 05:53:20"

    But i am expecting a result like this "1900/01/01 05:30:00"

    can any one help me.....

  2. #2
    Join Date
    Jun 2010
    I executed the following:

    select cast('05:30:00' as datetime)

    and got "1/1/1900 5:30:00.000 AM"
    Please always reply to the post if it was helpful. Others may find it helpful.

Tags for this Thread

Posting Permissions

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