Delphi Database, Delphi Components from ComponentAce
Products Download Order Contact us
Date Functions
Previous  Top  Next



Absolute Database supports the following Date/Time functions:

Function
Description
CURRENT_DATE
Returns the current date
CURRENT_TIME
Returns the current time
CURRENT_TIMESTAMP
Returns the current local date and local time as a timestamp value
NOW
Returns current date and time as a timestamp value
SYSDATE
Returns current date and time as a timestamp value
TOSTRING
Converts date and time to string
TODATE
Converts string to date and time
EXTRACT
Extracts datepart component from datetime value as INTEGER



CURRENT_DATE

Returns the current date.

Example:
CURRENT_DATE returns 01/01/2003 (for example)  
 
 
CURRENT_TIME

Returns the current time.

Example:
CURRENT_TIME returns 10:25:01 AM (for example)  
 
 
CURRENT_TIMESTAMP, NOW, SYSDATE

Returns the current local date and local time as a timestamp value.

Example:
CURRENT_TIMESTAMP returns 01/01/2003 10:25:01 AM (for example)  
 
 
TOSTRING (datetime_expr, date_format )

Converts date and/or time expression in datetime_expr to string in accordance with date_format format string.
The following is a list of options for the date_format parameter. These parameters can be used in many combinations.


Parameter
Description
D
Displays the day as a number without a leading zero (1-31).   
DD
Displays the day as a number with a leading zero (01-31).
DDD
Displays the day as an abbreviation (Sun-Sat).
DAY
Displays the day as a full name (Sunday-Saturday) using the strings given by the LongDayNames global variable.
DY
Day of year (1-366).
DW
Day of week (1-7).
M
Displays the month as a number without a leading zero (1-12).
MM
Displays the month as a number with a leading zero (01-12).
MON
Displays the month as an abbreviation (Jan-Dec) using the strings given by the ShortMonthNames global variable.
MONTH
Displays the month as a full name (January-December) using the strings given by the LongMonthNames global variable.
RM
Roman numeral month (I-XII; JAN = I).
YY
Displays the year as a two-digit number (00-99).
YYYY, YEAR
Displays the year as a four-digit number (0000-9999).
H, H12
Hour of day without a leading zero (1-12).
H24
Hour of day without a leading zero (1-24).
HH, HH12
Hour of day with a leading zero (01-12).
HH24
Hour of day with a leading zero (01-24).
N
Displays the minute without a leading zero (0-59).
NN
Displays the minute with a leading zero (00-59).
S
Displays the second without a leading zero (0-59).
SS
Displays the second with a leading zero (00-59).
AMPM
Uses the 12-hour clock for the preceding h or hh specifier, and displays 'AM' for any hour before noon, and 'PM' for any hour after noon.
Q
Quarter of year (1, 2, 3, 4; JAN-MAR = 1).
'Text', "Text"   
Characters enclosed in single or double quotes are displayed as-is, and do not affect formatting.
:
Displays the time separator character ':'.
/
Displays the date separator character '/'.
,
Displays the character ','.
.
Displays the character '.'.
;
Displays the character ';'.
-
Displays the character '-'.



Example:
TOSTRING(NOW,'mm/dd/yyyy') returns 01/01/2003 (for example)  
 
 
TODATE (string_expr, date_format )

Converts string in string_expr to to date and/or time expression in accordance with date_format format string.
The following is a list of options for the date_format parameter. These parameters can be used in many combinations.

Parameter
Description
D
Displays the day as a number without a leading zero (1-31).   
DD
Displays the day as a number with a leading zero (01-31).
M
Displays the month as a number without a leading zero (1-12).
MM
Displays the month as a number with a leading zero (01-12).
YY
Displays the year as a two-digit number (00-99).
YYYY, YEAR
Displays the year as a four-digit number (0000-9999).
H, H12
Hour of day without a leading zero (1-12).
H24
Hour of day without a leading zero (1-24).
HH, HH12
Hour of day with a leading zero (01-12).
HH24
Hour of day with a leading zero (01-24).
N
Displays the minute without a leading zero (0-59).
NN
Displays the minute with a leading zero (00-59).
S
Displays the second without a leading zero (0-59).
SS
Displays the second with a leading zero (00-59).
AMPM
Uses the 12-hour clock for the preceding h or hh specifier, and displays 'AM' for any hour before noon, and 'PM' for any hour after noon.
'Text', "Text"   
Characters enclosed in single or double quotes are displayed as-is, and do not affect formatting.
:
Displays the time separator character ':'.
/
Displays the date separator character '/'.
,
Displays the character ','.
.
Displays the character '.'.
;
Displays the character ';'.
-
Displays the character '-'.



Example:
TODATE('01/01/2003','mm/dd/yyyy') returns 01/01/2003  
 
 
 
EXTRACT (date_part FROM datetime_expression)

Extracts datepart component from datetime value as INTEGER.

date_part could be one of the following expressions:
date_part
Range
YEAR
1 to 9999
MONTH
1 to 12
DAY
1 to 31
HOUR
0 to 23
MINUTE
0 to 59
SECOND
0 to 59



Example:
EXTRACT (YEAR FROM date_field) returns 2003 (for example if date_field value is 01/01/2003)  
 
 
 
 
        © 2003 - 2017 ComponentAce  | .net zip component | barcode for .net | delphi zip component | delphi database Jan 16, 2017