Wiki source for CatPgDate


Show raw source

{{fbdoc item="title" value="Date and Time Functions"}}----
Procedures that work with dates and time.

{{fbdoc item="desc"}}
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.

**{{anchor name="VBCOMPAT|VisualBasic compatible procedures"}}**
Procedures for working with so-called [[ProPgDates|date serials]], similar to those used in Visual Basic(r).
**{{anchor name="DATETIME|Date and time procedures"}}**
Procedures for working with the system date and time.

<<{{anchor name="VBCOMPAT"}}{{fbdoc item="section" value="VisualBasic compatible procedures"}}
=={{fbdoc item="keyword" value="KeyPgNow|NOW"}}==
Gets a [[ProPgDates|date serial]] of the current date and time.

{{fbdoc item="subsect" value="Creating Date serials"}}
=={{fbdoc item="keyword" value="KeyPgDateSerial|DATESERIAL"}}==
Gets the [[ProPgDates|date serial]] representation of a date.
=={{fbdoc item="keyword" value="KeyPgTimeserial|TIMESERIAL"}}==
Gets the [[ProPgDates|date serial]] representation of a time.
=={{fbdoc item="keyword" value="KeyPgDateValue|DATEVALUE"}}==
Gets the [[ProPgDates|date serial]] representation of a date expressed as a ##[[KeyPgString|string]]##.
=={{fbdoc item="keyword" value="KeyPgTimeValue|TIMEVALUE"}}==
Gets the [[ProPgDates|date serial]] representation of a time expressed as a ##[[KeyPgString|string]]##.

{{fbdoc item="subsect" value="Extracting information from Date serials"}}
=={{fbdoc item="keyword" value="KeyPgSecond|SECOND"}}==
Gets the seconds of the hour from a [[ProPgDates|date serial]].
=={{fbdoc item="keyword" value="KeyPgMinute|MINUTE"}}==
Gets the minutes of the hour from a [[ProPgDates|date serial]].
=={{fbdoc item="keyword" value="KeyPgHour|HOUR"}}==
Gets the hour of the day from a [[ProPgDates|date serial]].
=={{fbdoc item="keyword" value="KeyPgDay|DAY"}}==
Gets the day of the month from a [[ProPgDates|date serial]].
=={{fbdoc item="keyword" value="KeyPgWeekday|WEEKDAY"}}==
Gets the day of the week from a [[ProPgDates|date serial]].
=={{fbdoc item="keyword" value="KeyPgMonth|MONTH"}}==
Gets the month of the year from a [[ProPgDates|date serial]].
=={{fbdoc item="keyword" value="KeyPgYear|YEAR"}}==
Gets the year from a [[ProPgDates|date serial]].
=={{fbdoc item="keyword" value="KeyPgDatePart|DATEPART"}}==
Gets a time interval from a [[ProPgDates|date serial]].

{{fbdoc item="subsect" value="Extracting information from Date serials"}}
=={{fbdoc item="keyword" value="KeyPgDateAdd|DATEADD"}}==
Gets the result of a time interval added to a [[ProPgDates|date serial]].
=={{fbdoc item="keyword" value="KeyPgDateDiff|DATEDIFF"}}==
Gets a time interval between two [[ProPgDates|date serial]]s.

{{fbdoc item="subsect" value="Miscellaneous"}}
=={{fbdoc item="keyword" value="KeyPgIsDate|ISDATE"}}==
Tests if a ##[[KeyPgString|String]]## can be converted to a [[ProPgDates|date serial]].
=={{fbdoc item="keyword" value="KeyPgMonthname|MONTHNAME"}}==
Gets the month name of its integer representation.
=={{fbdoc item="keyword" value="KeyPgWeekdayname|WEEKDAYNAME"}}==
Gets the weekday name of its integer representation.
<<>>{{anchor name="DATETIME"}}{{fbdoc item="section" value="Date and time procedures"}}
=={{fbdoc item="keyword" value="KeyPgDate|DATE"}}==
Gets the ##[[KeyPgString|string]]## representation of the current system date.
=={{fbdoc item="keyword" value="KeyPgTime|TIME"}}==
Gets the ##[[KeyPgString|string]]## representation of the current system time.
=={{fbdoc item="keyword" value="KeyPgSetdate|SETDATE"}}==
Sets the current system date.
=={{fbdoc item="keyword" value="KeyPgSettime|SETTIME"}}==
Sets the current system time.
=={{fbdoc item="keyword" value="KeyPgTimer|TIMER"}}==
Gets a counter expressed in seconds.
>>::c::

{{fbdoc item="back" value="DocToc|Table of Contents"}}
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki



sf.net phatcode