4.10. Datetime functions

4.10. Datetime functions
Prev	Up	Chapter 4. Functions	Home	Next

4.10.1. chgdateof() #

Change the date part of the first operand to the date part of the second operand. It takes two datetime operands.

4.10.2. chgtimeof() #

Change the time part of the first operand to the date part of the second operand. It takes two datetime operands.

4.10.3. date() #

Return the current date. It takes zero operands.

4.10.4. dateof() #

Return the date part. It takes one datetime operand.

4.10.5. day() #

Return the day of month value as a number. It takes one datetime operand.

4.10.6. dim() #

Returns the number of days in the month according to the year and month values of the operand. It takes one datetime operand.

4.10.7. dtos() #

Convert a datetime to string. The date part of the datetime is formatted according to the date format of the currently set locale. It takes one datetime operand.

4.10.8. dtosf() #

Convert a datetime to formatted string. It takes two operands, one datetime and one string. It takes the second (string) operand as a format string and formats the datetime value according to the format string. If the second operand is NULL or empty string, this function behaves like the dtos() function. Otherwise it behaves like the format() function with the operands reversed.

4.10.9. gettimeinsecs() #

Convert the time part of the datetime to seconds elapsed from 00:00:00. It takes one datetime operand.

4.10.10. interval() #

Convert the parameter(s) to an interval subtype of the datetime type. It takes either one string operand, or six numeric operands.

In the first case, the string is parsed for interval values, like 1 year or 2 months, etc., and sets the specific datetime part values.

In the second case, the six numeric operands are the values for the datetime parts, in the order of years, months, days, hours, minutes and seconds.

4.10.11. month() #

Return the month value of a datetime. It takes one datetime operand.

4.10.12. now() #

Return the current timestamp in a datetime value. It takes zero operands.

The "current timestamp" is determined at the beginning of generating the report. This function returns the same stable value for the lifetime of the report.

4.10.13. settimeinsecs() #

Return a datetime with the time part of a datetime changed to the specified seconds after 00:00:00. It takes two operands, the first operand is a datetime, the second is a numeric integer.

4.10.14. stdwiy() #

Return the ISO-8601 week number of a datetime as a decimal number, range 01 to 53, where week 1 is the first week that has at least 4 days in the new year. It takes one datetime operand.

4.10.15. stod() #

Alias for stodt().

4.10.16. stodt() #

Convert a string to a datetime value. It takes one string operand.

This function is smart enough to recognize locale specific and standard ISO-8601 formats. It handles whole datetime, date-only and time-only values in the string.

4.10.17. stodtsql() #

Alias for stodt().

4.10.18. timeof() #

Return time part of the datetime operand. It takes one datetime operand.

4.10.19. tstod() #

Alias for stodt().

4.10.20. wiy() #

Return the week number of the operand as a decimal number, range 00 to 53, starting with the first Sunday as the first day of week 01. It takes one datetime operand.

4.10.21. wiy1() #

Return the week number of the operand as a decimal number, range 00 to 53, starting with the first Monday as the first day of week 01. It takes one datetime operand.

4.10.22. wiyo() #

This function returns the week number of the first operand as a decimal number, range 00 to 53, starting with the specified day number as the first day. (0 = Sunday, 1 = Monday, 2 = Tuesday, ...) It takes two operands, the first is a datetime, the second is a numeric integer.

4.10.23. year() #

Return the year value of the operand as a numeric value. It takes one datetime operand.

Prev	Up	Next
4.9. String functions	Home	4.11. Type agnostic functions