Archives of the TeradataForum
Message Posted: Sat, 13 Apr 2013 @ 21:21:43 GMT
| Subj: | | Re: Getting TIME from TIMESTAMP |
| |
| From: | | Dieter Noeth |
Sukul Mahadik wrote:
| | I wish to extract TIME portion from the TIMESTAMP. | |
| | Some book I read says the following syntax should work : SELECT CAST(CURRENT_TIMESTAMP AS TIME); | |
Yes, that's the correct syntax.
| | However this does not work on my system . | |
What error code is returned? Do you use SQL Assistant plus ODBC?
Then there are three possible solutions:
- switch to the .NET Data Provider
- in the ODBC driver options: enable the "Disable Parsing" checkbox
- in the ODBC driver options: change the DateTimeFormat from to AAA
Dieter
| 
