DateDiff in sql server error - 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

SQL Server 2005 Forums

Transact-SQL (2005)

DateDiff in sql server error

Author

Topic

BrOkEn_iCe
Starting Member

25 Posts

Posted - 2010-06-27 : 04:23:22

hi
i want to know what is the wrong with


SELECT 
		DateDiff("d",[meter_status_date],Date()) AS period
FROM
		meter_table

it get me that ''Date' is not a recognized built-in function name.'

Sachin.Nand

2937 Posts

Posted - 2010-06-27 : 04:58:02

quote:
Originally posted by BrOkEn_iCe

hi
i want to know what is the wrong with

SELECT
DateDiff("d",[meter_status_date],GetDate()) AS period
FROM
meter_table

it get me that ''Date' is not a recognized built-in function name.'

Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless.

PBUH

BrOkEn_iCe
Starting Member

25 Posts

Posted - 2010-06-27 : 05:08:22

thx alot it work i don't why i miss this

thx again

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources