month 相关的搜索结果 共有6个

Date/Time Functions

  esProc offers date/time functions that return date, time and datetime values. Ø  age() Compute the number of whole yeafunction,year,month,day,quater

age()

Description: Compute the number of whole years between a specified date and the current time Syntax: age(dateExp{, formatime,interval,year,month,day

day()

Description: Get the day from a date value. Syntax: day(dateExp) Note: The function gets the day from dateExp of date tydate value,month

days()

Description: Get the number of days of the year, quarter or month to which the specified date belongs. Syntax: days(datespecified date,year,quarter,month,number of days,integer

elapse()

Description: Get the date/time which is a certain time period before or after a given date/time. Syntax: elapse(dateExp,new date,year,quarter,month,day

month()

Description: Get the month from a specified date/datetime value. Syntax: month(dateExp) Note: The function gets the mont specified date,month