Revision [12045]

This is an old revision of CatPgDate made by ElSairon on 2008-01-03 17:56:12.

 

Date and Time Functions


Procedures that work with dates and time.

Description:
These procedures provide ways to deal with date and time intervals in a consistent way. Additional procedures are provided to set and get the current system date and time, and to retrieve a time stamp for sensitive timing algorithms.

VisualBasic compatible procedures
Procedures for working with so-called ProPgDates date serials, similar to those used in Visual Basic(r).
Date and time procedures
Procedures for working with the system date and time.

VisualBasic compatible procedures
NOW
Gets a ProPgDates date serial of the current date and time.
Creating Date serials
DATESERIAL
Gets the ProPgDates date serial representation of a date.
TIMESERIAL
Gets the ProPgDates date serial representation of a time.
DATEVALUE
Gets the ProPgDates date serial representation of a date expressed as a KeyPgString string.
TIMEVALUE
Gets the ProPgDates date serial representation of a time expressed as a KeyPgString string.
Extracting information from Date serials
SECOND
Gets the seconds of the hour from a ProPgDates date serial.
MINUTE
Gets the minutes of the hour from a ProPgDates date serial.
HOUR
Gets the hour of the day from a ProPgDates date serial.
DAY
Gets the day of the month from a ProPgDates date serial.
WEEKDAY
Gets the day of the week from a ProPgDates date serial.
MONTH
Gets the month of the year from a ProPgDates date serial.
YEAR
Gets the year from a ProPgDates date serial.
DATEPART
Gets a time interval from a ProPgDates date serial.
Extracting information from Date serials
DATEADD
Gets the result of a time interval added to a ProPgDates date serial.
DATEDIFF
Gets a time interval between two ProPgDates date serials.
Miscellaneous
ISDATE
Tests if a KeyPgString String can be converted to a ProPgDates date serial.
MONTHNAME
Gets the month name of its integer representation.
WEEKDAYNAME
Gets the weekday name of its integer representation.
Date and time procedures
DATE
Gets the KeyPgString string representation of the current system date.
TIME
Gets the KeyPgString string representation of the current system time.
SETDATE
Sets the current system date.
SETTIME
Sets the current system time.
TIMER
Gets a counter expressed in seconds.
 


Back to Table of Contents
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki



sf.net phatcode