Archives of the TeradataForum

Message Posted: Thu, 06 Mar 2003 @ 16:52:16 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Year values in teradata

From:		Dieter N�th

Voulgari, Litsa wrote:

I am looking for a way to insert for example the year value 2003 when inserting the year value 03 in teradata. Currently what is inserted is 1903 in the year field.

If a two digit year is 19xx or 20xx is set using dbscontrol: general field 14: century break

Dieter


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Archives

2016		2007
2015		2006
2014		2005
2013		2004
2012		2003
2011		2002
2010		2001
2009		2000
2008		1999

2003 Indexes

Jan		Jul
Feb		Aug
Mar		Sep
Apr		Oct
May		Nov
Jun		Dec

Last Modified: 15 Jun 2023