Operations with date and time values; transformations, formatting.

 

DayOf

obtain the number of the day of the month from the specified date;

DayOfTheWeek

obtain the day of the week by the specified date;

DaysBetween

how many whole days between two specified dates;

DecodeDate

obtain the year, month and day values from the date variable;

DecodeDateTime

obtain the year, month, day, hour, minute, second and millisecond values from the date/time variable;

EncodeDate

obtain the date from the year, month and day values;

EncodeDateTime

obtain the date from the year, month, day, hour, minute, second and millisecond values;

EndOfTheDay

date and time values of the end of the day from the specified date;

EndOfTheMonth

date and time values of the end of the month from the specified date;

EndOfTheWeek

date and time values of the end of the week from the specified date;

EndOfTheYear

date and time values of the end of the year from the specified date;

FormatDateTime

converting the date and time into the text string by the specified format;

HourOf

obtain an hour value of the day from the specified date;

HoursBetween

how many whole hours between two specified dates;

IncDay

add or subtract the number of days to the specified date;

IncHour

add or subtract the number of hours to the specified date;

add or subtract the number of milliseconds to the specified date;

add or subtract the number of minutes to the specified date;

add or subtract the number of months to the specified date;

add or subtract the number of seconds to the specified date;

add or subtract the number of weeks to the specified date;

IncYear

add or subtract the number of years to the specified date;

LocalTimeToUTC

convert the date and time value to UTC;

MilliSecondsBetween

quantity of milliseconds between two specified dates;

MinuteOf

obtain the minute of the hour from the specified date;

MonthOf

obtain the month of the year from the specified date;

MonthsBetween

quantity of months between two specified dates;

NoDate

get the value "no date and time";

Now

obtain the current date and time value;

SecondOf

obtain the second of the minute from the the specified date;

SecondsBetween

seconds quantity between two specified dates;

StartOfTheDay

date/time value of the start of the day from the specified date;

StartOfTheMonth

date/time value of the start of the month from the specified date;

StartOfTheWeek

date/time value of the start of the week from the specified date ;

StartOfTheYear

date/time value of the start of the year from the specified date;

UTCToLocalTime

convert UTC date/time value into the local time;

WeekOf

return the week of the year from the specified date;

WeeksBetween

how many weeks between two dates;

YearOf

returns the year from the specified date;

YearsBetween

how many whole years between two specified dates.