All Forums Database
aolympio 25 posts Joined 04/09
09 Apr 2009
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

aolympio 25 posts Joined 04/09
13 Apr 2009

Please, somebody knows how to resolve this problem?I didn`t find any solution. :(Thanks for help!

Adeel Chaudhry 773 posts Joined 04/08
14 Apr 2009

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

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.