SQLServerCentral / Discuss content posted by Additional Articles / Article Discussions / Article Discussions by Author / Current date without the timestamp / Latest Posts

RE: Current date without the timestamp

Michael Valentine Jones — Fri, 29 Oct 2010 10:13:26 GMT

If you are using DATETIME, these are better ways to get today at 00:00:00.000. The nested DATEADD and DATEDIFF are a more efficient way to do this conversion than conversion to a character string and back again to DATETIME.[code="sql"]Select dateadd(day,datediff(day,0,current_timestamp),0) as CurrDateSelect dateadd(day,datediff(day,0,getdate()),0) as CurrDate[/code]If you are using SQL 2008 or later, then the way Joe Celko suggested will work fine if you want a DATE column.If you need a DATETIME, this also works in SQL 2008 or later:[code="sql"]select convert(datetime,convert(date,current_timestamp)) as CurrDate[/code]

RE: Current date without the timestamp

CELKO — Fri, 29 Oct 2010 09:55:14 GMT

Use the newer ANSI stuff so you get a real DATE data type and not a DATETIME: CAST (CURRENT_TIMESTAMP AS DATE)

Current date without the timestamp

Site Owners — Sun, 30 Sep 2007 06:39:19 GMT

Comments posted to this topic are about the item [B]Current date without the timestamp[/B]