Current date only

[netcert]

I'm trying to get the current system date without the time. I know I can use GetDate() but I don't want the time portion.

Isn't there a separate function just for date or am I going to have to use the convert syntax to pull it out?

What would the syntax be?

 

[gmmastros]

Read this... faq183-5842

Particulary item #7.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

deja-vu

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[vongrunt]

Actually de-de-de-deja-vu (sfx on)

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]

 

[gmmastros]

I just now read that other thread. I swear it's true.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[netcert]

what i'm really looking for is a way to pull records that were updated on the current date only. This script would only pull those records who were last updated, today, for example.

select * from name where last_updated = current date only

The Last_Updated field is a datetime so I only want to compare the date portion with the date portion of todays date, minus the time.

The FAQ you all referenced was helpful but maybe i'm just not getting it.

Thx.

 

[gmmastros]

In the FAQs...

DATEADD(dd, DATEDIFF(dd, 0, [!]GETDATE()[/!]), 0)

so...

select * 
from   name 
where  DATEADD(dd, DATEDIFF(dd, 0, [!]last_updated[/!]),0) 
          = DATEADD(dd, DATEDIFF(dd, 0, [!]GETDATE()[/!]), 0)

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

red, the color of anger ;-)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[vongrunt]

Um... bye-bye SARG

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]