Date format - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Date format

Author

Topic

mjimenezh
Yak Posting Veteran

81 Posts

Posted - 2015-04-27 : 16:19:53

Hi, I have an sql 2008 instruction when I filtered by Date but I need to change the Date (dd'2015-04-27') by something like this:
dd(GETDATE())

How can I do that?

This is the instruction I have :

ISNULL(ISNULL(bt.InvoiceDate,bt.ProcessingDate),bt.Valuedate) <= {d '2015-04-27'}

Thanks in advance

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-04-27 : 16:34:50

select convert(char(10), getdate(), 120)

mjimenezh
Yak Posting Veteran

81 Posts

Posted - 2015-04-27 : 16:46:03

Thanks Gbritton, it works

Regards...

quote:
Originally posted by gbritton

select convert(char(10), getdate(), 120)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources