datetime Question

• neddyflanders

  SSC Eights!

  Points: 972

  More actions

  November 11, 2004 at 2:39 pm

  #182623

  hello, I am trying to get the date to come out without milliseconds. Below is the script I'm using but it displays 2004-11-11 16:29:14.887

  select 1 as KeyID, getdate() as datetime_text

  how do I get rid of the milliseconds?

• PBirch

  SSCrazy Eights

  Points: 8493

  More actions

  November 11, 2004 at 3:09 pm

  #529849

  BOL (Books on Line) will help with this.

  Select 1 as keyID,CONVERT(smalldatetime, getdate(),120) as datetime_text

  Quand on parle du loup, on en voit la queue