dbdatepart

Description

Return the specified part of a DBDATETIME value as a numeric value.

Syntax

DBINT dbdatepart(dbproc, datepart, datetime)
 
DBPROCESS     *dbproc;
int                       datepart;
DBDATETIME     *datetime;

Parameters

dbproc: A pointer to the DBPROCESS structure that provides the connection for a particular front-end/server process. It contains all the information that DB-Library uses to manage communications and data between the front end and server.

datepart

The date component of interest. Table 2-16 lists the date parts, the date part symbols recognized by DB-Library and the expected values. Note that the names of the months and the days in this table are those for English.

**Table 2-16: Date parts and their character representations (dbdatepart)**
Date part	Symbol	Character representation of value
year	DBDATE_YY	1753 – 9999
quarter	DBDATE_QQ	1 – 4
month	DBDATE_MM	January – December
day of year	DBDATE_DY	1 – 366
day	DBDATE_DD	1 – 31
week	DBDATE_WK	1 – 54 (for leap years)
weekday	DBDATE_DW	Monday – Sunday
hour	DBDATE_HH	0 – 23
minute	DBDATE_MI	0 – 59
second	DBDATE_SS	0 – 59
millisecond	DBDATE_MS	0 – 999

datetime: A pointer to the DBDATETIME value of interest.

Returns

The value of the specified date part.

Usage

dbdatepart returns the specified part of a DBDATETIME value as a numeric value.
dbdatepart is similar to the Transact-SQL datepart function.