DateTime Extension Functions tool palette
| 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 | Supported Transformation Functions
Boolean Functions Tool Palette Conditional Logic Functions Tool Palette Node Set Functions Tool Palette Numeric Extension Functions Tool Palette String Extension Functions Tool Palette Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com |