Answers for "how to get date from timestamp in sql"

sql display today's date

SELECT getdate()

Posted by: Guest on April-28-2020

sql get date from timestamp

SELECT title, date(timestamp) AS MYDATE
FROM Team_Note TN
WHERE id = 1

Posted by: Guest on August-29-2021

sql server format datetime to short date

CONVERT ( data_type [ ( length ) ] , expression [ , style ] )

Posted by: Guest on June-17-2020

Code answers related to "how to get date from timestamp in sql"