OdbcDate2Date

Syntax

OdbcDate2Date(str_date_time);

str_date_time

A string containing date and time.

Description

Extracts the date from a date and time string in the following format:

date time

Returns

date	The date extracted from a string containing date and time.

Example

A column of the smalldatetime SQL data type could be returned from the data source as:

2002-01-01 15:48:00

In this case, OdbcDate2Date would return:

2002-01-01