Post reply

Date truncation problem

  • June 15, 2005 at 2:08 pm

    #167172

    I had to convert "2005-05-17 16:35:49.000" date to string using

    CAST(a.ps_ActImplDate AS varchar(20)), 'Not Assigned'), since I had to assign "not assigned" to all null dates

    Problem here is when I am displaying date in string format it is only displaying like "May 17 2005 4:35PM" missing seconds part. I need everything because I need to query using same date on other table. How to convert datetime to string without any truncation

    Following a snapshot of how it each datetime looks before and after conversion

    2005-05-17 16:35:49.000 May 17 2005 4:35PM

    2005-05-17 16:27:03.000 May 17 2005 4:27PM

    2005-05-17 16:27:03.000 May 17 2005 4:27PM

    2005-05-17 16:35:48.000 May 17 2005 4:35PM

  • June 15, 2005 at 2:32 pm

    #565906

    When you CAST'ed the DATETIME you lost the seconds.  You cannot get them back from already CAST'ed values.  However, Try this conversion for FUTURE date conversions IF you need seconds...  SELECT CONVERT(VARCHAR(20), @Date, 109)



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • June 16, 2005 at 7:05 am

    #566057

    Maybe I'm wrong but : 2005-05-17 16:35:48.000 May 17 2005 4:35PM

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

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