How do I truncate the time from a date

• 
  There is an old but still excellent article from Robyn Page, on various ways to manipulate data/time information - https://www.red-gate.com/simple-talk/sql/learn-sql-server/robyn-pages-sql-server-datetime-workbench/

  BrainDonor February 19, 2021 08:30

  - 0 +
• 
  Try this:
   SELECT cast(getDate() As Date) 
  If this looks good for you, replace ''getDate()' with the name of column that holds the datetime data.
  JR

  JR_GER February 19, 2021 08:32

  - 0 +

Add comment

Please sign in to leave a comment.