CONVERT and DATEDIFF in Teradata

Database
Enthusiast

CONVERT and DATEDIFF in Teradata

Hi!

I want to know how can I use these commands (from SQL Server) in Teradata because i need to obtain the similar functionality: and .

For example:

SELECT FIELD FROM TABLE1 WHERE (DATEDIFF(ss,(SELECT FIELD1 FROM TABLE1), SOME_DATE));

SELECT CONVERT(VARCHAR(23),ACM_DATE,121) FROM TABLE1;

Thanks for help,
Anderson

2 REPLIES
Enthusiast

Re: CONVERT and DATEDIFF in Teradata

Please, somebody knows how to resolve this problem?

I didn`t find any solution. :(

Thanks for help!

Teradata Employee

Re: CONVERT and DATEDIFF in Teradata

http://www.teradata.com/teradataforum/FindPost15071.aspx