Re: Date fornat on Informix

Posted in 1998

Wolfgang Beutner — Sat, 20 Jun 1998 19:17:00 GMT — source: Informix-list mailing list archive (1991-1998)

>>>>>>>>>>>>>>>>>> Urspr=FCngliche Nachricht <<<<<<<<<<<<<<<<<< Am 20.06.98, 20:32:00, schrieb "Albert Fern=E1ndez Marsal"=20 <alberfm@tinet.fut.es> zum Thema Date fornat on Informix: >=20 > I'm using Informix v 7.0 (in a unix platform), and it's default=20= date > format is d/m/y (spanish format). i must insert some values from a=20= file in > the m/d/y format. >=20 > anyone knows how to change the default date format for Informix?!?= >=20 You should set the shell-variable DBDATE in the environment of user=20 informix to the desired format before you start the server. See the=20 documentation for the applicable formts. I think for you it should be=20= DBDATE=3DMMDDYY; export DBDATE. Greetings Wolfgang from Dortmund, Germany.