Conversion to CS_CHAR

The cs_dt_info routine sets or retrieves language-specific date, time, or datetime information. The date conversion format, which you can set or retrieve by calling cs_dt_info with the type parameter value of CS_DT_CONVFMT, describes the format of the result when a CS_BIGDATETIME or CS_BIGTIME value is converted to a character-based datatype.

Table 10: Values for *buffer when type is CS_DT_CONVFMT (cs_dt_info)

Symbolic value

CS_CHAR converted from CS_BIGDATETIME, for example: Aug 24 2009 5:36PM

CS_CHAR converted from CS_DATE, for example: Aug 24 2009

CS_CHAR converted from CS_BIGTIME, for example: 5:36PM

CS_DATES_ HMSUSA, or

CS_DATES_ HMSUSA_YYYY

hh:mm:ss.zzzzzz[AM|PM]

5:36:00.000000PM

hh:mm:ss.zzzz[AM|PM]

12:00:00:000000AM

hh:mm:ss.zzzz[AM|PM]

5:36:00.000000PM

CS_DATES_ HMSUS, or

CS_DATES_ HMSUS_YYYY

hh:mm:ss.zzzzzz

17:36:00.000000

hh:mm:ss.zzzzzz

00:00:00.000000

hh:mm:ss.zzzzzz

17:36:00.000000

CS_DATES_ LONGUSA

mon dd yy hh:mm:ss.zzzzzz[AM|PM]

Aug 24 09 5:36:00.000000PM

mon dd yy hh:mm:ss.zzzzzz[AM|PM]

Aug 24 09 12:00:00.000000AM

mon dd yy hh:mm:ss.zzzzzz[AM|PM]

Jan 1 01 5:36:00.000000PM

CS_DATES_ LONGUSA_YYYY

mon dd yyyy hh:mm:ss.zzzzzz[AM|PM]

Aug 24 2009 5:36:00.000000PM

mon dd yyyy hh:mm:ss.zzzzzz[AM|PM]

Aug 24 2009 12:00:00.000000AM

mon dd yyyy hh:mm:ss.zzzzzz[AM|PM]

Jan 1 0001 5:36:00.000000PM

CS_DATES_ LONGUS

mon dd yy hh:mm:ss.zzzzzz

Aug 24 09 17:36:00.000000

mon dd yy hh:mm:ss.zzzzzz

Aug 24 09 00:00:00.000000

mon dd yy hh:mm:ss.zzzzzz

Jan 1 01 17:36:00.000000

CS_DATES_ LONGUS_YYYY

mon dd yyyy hh:mm:ss.zzzzzz

Aug 24 2009 17:36:00.000000

mon dd yy hh:mm:ss.zzzzzz

Aug 24 2009 00:00:00.000000

mon dd yy hh:mm:ss.zzzzzz

Jan 1 0001 17:36:00.000000

CS_DATES_ YMDHMSUS_YYYY

yyyy-mm-dd hh:mm:ss.zzzzzz

2009-08-24 17:36:00.000000

yyyy-mm-dd hh:mm:ss.zzzzzz

2009-08-24 00:00:00.000000

yyyy-mm-dd hh:mm:ss.zzzzzz

0001-01-01 17:36:00.000000