Post reply

Time Stamp Error

  • October 3, 2006 at 8:13 am

    #169961

    Hello,

    I'm a newbie to Sybase, I need to write a time stamp with milliseconds.

    I currently have "convert(char(30),CrpsRvnTs,109)CrpsRvnTs, (char(30)AsOfTs,109) " in my code but I'm getting an error.

    Is there is any suggestions on what I'm doing wrong?

    Thanks!

  • October 3, 2006 at 8:37 am

    #663847

    try this out

    SELECT CONVERT(CHAR(30),GETDATE(),109) AS TimeStamp

  • October 3, 2006 at 10:10 am

    #663888

    Thanks,that worked.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply