DATE
DATE
DATE(2008, 7, 8)
Tue Jul 08 2008 00:00:00 GMT-0700 (PDT)
DATEVALUE
DATEVALUE('8/22/2011')
Mon Aug 22 2011 00:00:00 GMT-0700 (PDT)
DAY
DAY('15-Apr-11')
15
DAYS
DAYS('3/15/11', '2/1/11')
42
DAYS360
DAYS360('1-Jan-11', '31-Dec-11')
360
EDATE
EDATE('1/15/11', -1)
Wed Dec 15 2010 00:00:00 GMT-0800 (PST)
EOMONTH
EOMONTH('1/1/11', -3)
Sun Oct 31 2010 00:00:00 GMT-0700 (PDT)
HOUR
HOUR('7/18/2011 7:45:00 AM')
7
MINUTE
MINUTE('2/1/2011 12:45:00 PM')
45
ISOWEEKNUM
ISOWEEKNUM('3/9/2012')
10
MONTH
MONTH('15-Apr-11')
4
NETWORKDAYS
NETWORKDAYS('10/1/2012', '3/1/2013', ['11/22/2012'])
109
NETWORKDAYSINTL
NETWORKDAYSINTL('1/1/2006', '2/1/2006', 7, ['1/2/2006'])
23
NOW
NOW()
Thu Feb 20 2020 23:02:55 GMT+0100 (Central European Standard Time)
NOW2
NOW2()
2024-02-22 10:55:23
NOWTIME
NOWTIME()
14:22:23
SECOND
SECOND('2/1/2011 4:48:18 PM')
18
TIME
TIME(16, 48, 10)
0.700115741
TIMEVALUE
TIMEVALUE('22-Aug-2011 6:35 AM')
0.274305556
TODAY
TODAY()
Thu Feb 20 2020 23:02:55 GMT+0100 (Central European Standard Time)
WEEKDAY
WEEKDAY('2/14/2008', 3)
3
YEAR
YEAR('7/5/2008')
2008
WEEKNUM
WEEKNUM('3/9/2012', 2)
11
WORKDAY
WORKDAY('10/1/2008', 151, ['11/26/2008', '12/4/2008'])
Mon May 04 2009 00:00:00 GMT-0700 (PDT)
WORKDAYINTL
WORKDAYINTL('1/1/2012', 30, 17)
Sun Feb 05 2012 00:00:00 GMT-0800 (PST)
YEARFRAC
YEARFRAC('1/1/2012', '7/30/2012', 3)
0.578082192
Last updated