 |
 |
Archives of the TeradataForum
Message Posted: Fri, 23 Nov 2007 @ 13:30:11 GMT
| Subj: | | Re: Coalesce on timestamps |
| |
| From: | | Dieter Noeth |
Anomy.Anom wrote:
| | The following statement gives a 2800 error | |
| | select COALESCE(ins_dtm, CURRENT_TIMESTAMP) FROM table1 | |
| | The field ins_dtm is of the type timestamp(6). Any one an idea? | |
SELECT TYPE(CURRENT_TIMESTAMP);
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
Type(Current TimeStamp(6))
---------------------------------------
TIMESTAMP(6) WITH TIME ZONE
-> COALESCE(ins_dtm, CAST(CURRENT_TIMESTAMP AS TIMESTAMP))
Dieter
| |
