 |
 |
Archives of the TeradataForum
Message Posted: Thu, 09 Jan 2003 @ 20:36:53 GMT
| Subj: | | Re: FORMAT Problem |
| |
| From: | | John Grace |
Tony,
I think (and this does go back a while) the SQL syntax (the FORMAT clause) you are using is Teradata specific not ANSI SQL. (Can
you run the query without the FORMAT?)
CAST is the preferred SQL-92 method, but I am not sure what you are casting from and to. Syntax CAST(Your_Date as data_type) where
datatype is a teradata supported datatype.
SQL Server supports Convert which is nice, but not SQL-92.
John
| |
