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.
| Author |
Topic |
|
fenicon
Starting Member
2 Posts |
 Posted - 2010-11-04 : 12:56:53
|
| I am getting an error when I run the query below with the datediff function. Any help would be appreciated. Thanks!SELECT DATEDIFF(h.SETUP_DT,(SELECT MAX(h.SETUP_DT)FROM survey_response_header h)) FROM survey_response_header h=====================================ERROR: Function 'DATEDIFF(TIMESTAMP, TIMESTAMP)' does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts (State:42S02, Native Code: 1D) |
|
|
fenicon
Starting Member
2 Posts |
Posted - 2010-11-04 : 13:00:11
|
| Additional note to the topic above:I'm querying from Netezza database using WinSQL. Thanks!-Fenico |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-11-04 : 13:57:37
|
| This forum if for questions about Microsoft SQL Server.You should consult the Netezza documentation to find out how to do what you want.CODO ERGO SUM |
|
|
|
|
|
|
DATEDIFF function