SQL Date from DateTime

  2. Categories
  3. Date+Time
  4. SQL Date from DateTime

Extract Date from Datetime field in SQL
An old method I found in my archive.

CodeFunctionName
What is this?

Public

Not Tested

Imported


Select convert(datetime,convert(char(10),getdate(),101))

Views 228

Downloads 66

CodeID
DB ID
SQL
Date+Time

ANmarAmdeen
610
Attachments
Revisions

v1.0

Wednesday
November
29
2023
Tags
sql date time datetime day month year seconds hours minutes convert extract change replace getdate char select NotMyWork