Oninit cdi / Archive
Talk to an expert →

RE: ESQL/C dtcvfmtasc()

Posted in 1999

Topics: Installation, Setup & Upgrades, Connectivity: ESQL/C, 4GL & Embedded SQL

William Raper — — source: Informix-list mailing list archive (1991-1998)

Try with a valid date. 2/29/1999 is not valid. Try with 2/29/2000. -----Original Message----- From: jlk62@aol.com32Qfree [mailto:jlk62@aol.com32Qfree] Sent: Wednesday, October 06, 1999 11:45 AM To: informix-list@iiug.org Subject: ESQL/C dtcvfmtasc() After having found that certain versions of Informix (both SE and IDS) don't support the leap year date (Feb 29, 2000), I upgraded IDS to version 7.30.UC2 (SCO Openserver). I can now see that the leap year date works. However, to insert a date/time doesn't - using the following: dtcvfmtasc("022999 000109", "%m%d%y %H%M%S", &date_time_varaible) fails. My version of ESQL is 7.22.UC2. I'll look to upgrade this (if possible), but I was wondering if anyone else had come across this? Thanks. Joe

↪ replying to William Raper
JLK62 — — source: Informix-list mailing list archive (1991-1998)

Sorry, that should have been: dtcvfmtasc("022900 000109", "%m%d%y %H%M%S", &date_time_varaible) with DBCENTURY set to 'C'.

Glossary