w3ka dev - share the knowledge .NET
3 ways to get date in SQL without time
Here are 3 ways of getting date-only part of timestamp in SQL Server:
1. DATEADD( DAY, 0 , DATEDIFF(DAY,0, CURRENT_TIMESTAMP) )
2. CONVERT( datetime, FLOOR(CONVERT(float(24), GETDATE())) )
3. CAST( CONVERT(CHAR(8), GETDATE(),112) as DATETIME)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment