INFORMIX-ESQL/C Programmer's Manual ESQL/C Function Library

The dtcvasc() function converts a string that conforms to ANSI SQL standard for a DATETIME value to a datetime value. For information about the ANSI SQL DATETIME standard, see page 6-15.

mint dtcvasc(inbuf, dtvalue)

	char *inbuf;

	dtime_t *dtvalue;

 



inbuf

is a pointer to the buffer that contains an ANSI-standard DATETIME string. 


dtvalue  

is a pointer to an initialized datetime variable. 

You must initialize the datetime variable in dtvalue with the qualifier that you want this variable to have.

The character string in inbuf must have values that conform to the year to second qualifier in the ANSI SQL format. The inbuf string can have leading and trailing spaces. However, from the first significant digit to the last, inbuf can only contain characters that are digits and delimiters that conform to the ANSI SQL standard for DATETIME values.

If you specify a year value as one or two digits, the dtcvasc() function assumes that the year is in the present century. You can set the DBCENTURY environment variable to determine which century dtcvasc() uses when you omit a century from the date.

If the character string is an empty string, the dtcvasc() function sets to null the value to which dtvalue points. If the character string is acceptable, the function sets the value in the datetime variable and returns zero. Otherwise, the function leaves the variable unchanged and returns a negative error code.

The demo directory contains this sample program in the dtcvasc.ec file.

/*
* dtcvasc.ec *

The following program converts ASCII datetime strings in ANSI SQL format
into datetime (dtime_t) structure.
*/

#include <stdio.h>

EXEC SQL include datetime;

main()
{
mint x;

EXEC SQL BEGIN DECLARE SECTION;
datetime year to second dt1;
EXEC SQL END DECLARE SECTION;

printf("DTCVASC Sample ESQL Program running.\n\n");

printf("Datetime string #1 = 1998-02-11 3:10:35\n");
if (x = dtcvasc("1998-02-11 3:10:35", &dt1))
printf("Result = failed with conversion error: %d\n", x);
else
printf("Result = successful conversion\n");

/*
* Note that the following literal string has a 26 in the hours place
*/
printf("\nDatetime string #2 = 1994-02-04 26:10:35\n");
if (x = dtcvasc("1998-02-04 26:10:35", &dt1))
printf("Result = failed with conversion error: %d\n", x);
else
printf("Result = successful conversion\n");

printf("\nDTCVASC Sample Program over.\n\n");
}

DTCVASC Sample ESQL Program running.

Datetime string #1 = 1998-02-11 3:10:35
Result = successful conversion

Datetime string #2 = 1998-02-04 26:10:35
Result = failed with conversion error:-1263

DTCVASC Sample Program over.