Archives of the TeradataForum
Message Posted: Tue, 15 Nov 2005 @ 14:07:10 GMT
| Subj: | | Re: Change the date format on the Teradata server |
| |
| From: | | Michael Larkins |
Teradata's internal date format on disk is ALWAYS the same (yyyymmdd). The only impact that users can have is on how it is displayed on output
and interpretted on input when using a character date format. The system has a default DATEFORM. If you are seeing it change from one system to
the other, then the issue is probably (haven't checked for sure) but my guess is that your new DBS Control record specifies the DATEFORM as
INTEGERDATE and you want ANSIDATE. This format can be over-ridden at the TABLE level in a CREATE TABLE as well as the session level with the
SET DATEFORM command or via an ANSI session. It can also be over-ridden at the request level with the FORMAT.
With that said, if you want all of your users to experience the same 'yyyy-mm-dd' format the control record is your best bet. The thing to
watch is that if you created your tables with the INTEGERDATE as the default, they may have the FORMAT 'yy/mm/dd' stored in them and this may also
need to be changed.
Hope this helps,
Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
| 
