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. The following table 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-15: 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.