db_date_to_date_c
db_date_to_date_c(db_date.i1a.r, date.i1a.r, convert_flags.u4.v
[,sybase_format.i4.v])
This routime converts a database date string to a date string
having the format "dd-Mmm-yyyy hh:mm:ss".
This routine will accept ";" characters in place of ":" characters in the
time portion of the input. (The use of ";" characters in place of ":"
characters is how date_to_clinks handles the repeated local times caused
by daylight savings time.) The routine will not preserve the ";"
characters; they will be changed to ":" characters.
db_date database format date string
date returned date string (DATE_STRING_LEN characters)
convert_flags conversion modifier flags (These values may be
logically ORed together.)
(DATE_NULL_TERMINATE -> null terminate the returned
date string,
DATE_NO_SECONDS -> don't include the seconds field
in the returned date string)
[sybase_format] Sybase date format ID
(0 or 100 -> date string having the format
"Mmm dd yyyy hh:mmAM(PM)"
(DB_DATE_LEN characters)
(default),
1 -> date string having the format "mm/dd/yy",
101 -> date string having the format "mm/dd/yyyy",
2 -> date string having the format "yy.mm.dd",
102 -> date string having the format "yyyy.mm.dd",
3 -> date string having the format "dd/mm/yy",
103 -> date string having the format "dd/mm/yyyy",
4 -> date string having the format "dd.mm.yy",
104 -> date string having the format "dd.mm.yyyy",
5 -> date string having the format "dd-mm-yy",
105 -> date string having the format "dd-mm-yyyy",
6 -> date string having the format "dd Mmm yy",
106 -> date string having the format "dd Mmm yyyy",
7 -> date string having the format "Mmm dd,yy",
107 -> date string having the format "Mmm dd,yyyy",
8 or 108 -> date string having the format "hh:mm:ss"
(not recommended),
9 or 109 -> date string having the format
"Mmm dd yyyy hh:mm:ss:mmmAM(PM)",
10 -> date string having the format "mm-dd-yy",
110 -> date string having the format "mm-dd-yyyy",
11 -> date string having the format "yy/mm/dd",
111 -> date string having the format "yyyy/mm/dd",
12 -> date string having the format "yymmdd",
112 -> date string having the format "yyyymmdd")
This function requires the following include files:
clib_h, acnet_errors_h
Related functions:
db_date_to_clinks, date_to_clinks, convert_compare_date_to_clinks,
clinks_to_date, clinks_now, clinks_to_day_of_week_c, get_date_clinks,
convert_seconds_c, clinks_to_special_time_c
C/C++ usage:
static const char db_date[DB_DATE_LEN+1] = "Sep 16 1997 04:00PM";
char date[DATE_STRING_LEN+1];
int sybase_format = 0;
unsigned int convert_flags = DATE_NULL_TERMINATE;
db_date_to_date_c(db_date,date,convert_flags,sybase_format);