The table in this topic describes the date and time extension functions available from the XPath editor context menu.
Name | Description |
---|---|
adjust datetime | Reformats the input date and time to match the given output format pattern |
current datetime formatted | Returns the current date and time using the specified format |
date diff | Returns the difference between two dates |
date part | Returns a particular part of the date |
format | Returns a date formatted to the specified format |
get day of month | Returns the day of the month |
get day of week | Returns the day of the week |
get day of year | Returns the day of the year |
get hour | Returns the hour as a 24-hour clock |
get hour 12 | Returns the hour as a 12-hour clock |
get minute | Returns the minute |
get month | Returns the month |
get name of day | Returns the name of the day |
get name of month | Returns the name of the month |
get second | Returns the second |
get time zone id | Returns the time zone |
get year | Returns the year |
set day of month | Sets the day of the month using a default datetime format |
set day of month with context | Sets the day of the month |
set day of week | Sets the day of the week using a default datetime format |
set day of week with context | Sets the day of the week |
set day of year | Sets the day of the year using a default datetime format |
set day of year with context | Sets the day of the year |
set hour | Sets the hour using a default datetime format |
set hour with context | Sets the hour |
set minute | Sets the minute using a default datetime format |
set minute with context | Sets the minute |
set month | Sets the month using a default datetime format |
set month with context | Sets the month |
set second | Sets the second using a default datetime format |
set second with context | Sets the second |
set year | Sets the year using a default datetime format |
set year with context | Sets the year |
transform date time | Reformats the input date and time to match the given output format pattern |
Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com
Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.