Archives of the TeradataForum
Message Posted: Sat, 06 Nov 2010 @ 17:49:03 GMT
Subj: | | Re: Question on Date Format in Teradata. |
|
From: | | RLavadi |
Sorry, there was typo in the format which I mentioned.
The below format it works, no issues.
2010-10-10 09.52.26.988960 (FORMAT 'YYYY-MM-DDBHH.MI.SS.SSSSSS')
The following is erroring out, tried by all means, still no luck !
01/10/2010 04:16:48.000000 (FORMAT 'MM/DD/YYYYBHH.MI.SS.SSSSSS')
Hope, this gives more clarification for you guys to think of any solution or tip for me. Thanks.
Ravikumar Lavadi
Vice President
Pershing Technology Group - NetExchange Information Delivery
|