set century on use patrons index dates list all for date = ctod("01/01/2003")
https://www.lianja.com/doc/index.php/SET_CENTURY
set date german use patrons index dates seek ctod("01.01.98") set century on seek ctod("01.01.1998")
https://www.lianja.com/doc/index.php/SET_DATE
set century off set epoch to 1995
https://www.lianja.com/doc/index.php/SET_EPOCH
set hours to 24
https://www.lianja.com/doc/index.php/SET_HOURS
set mark to "." ? date() 05.05.2000
https://www.lianja.com/doc/index.php/SET_MARK
set seconds off ? datetime() 01/23/2004 01:18 PM set seconds on ? datetime() 01/23/2004 01:18:22 PM
https://www.lianja.com/doc/index.php/SET_SECONDS
store cdow(date()) to dayofweek ? dayofweek Sunday dayofweek = cdow(date()) ? dayofweek Sunday dayofweek = cdow(datetime()) ? dayofweek Sunday
https://www.lianja.com/doc/index.php/CDOW()
? ampm() 07:30:24 pm
https://www.lianja.com/doc/index.php/AMPM()
// hh:mm:ss > ? timeofday() 14:43:26 > ? timeofday(0) 14:43:26 // xxx (milliseconds) > ? timeofday(1) 482 // hh:mm:ss:xxx (24hr) > ? timeofday(2) 14:44:41.012 // ss:xxx since midnight > ? timeofday(3) 53088.540 // ss:xxx since TIMEOFDAY() last called > ? timeofday(4) 5.248 // YYYYMMDDhh:mm:ss > ? timeofday(5) 2015110614:44:58 // YYYYMMDD > ? timeofday(6) 20151106 // ss:xxx since TIMEOFDAY() last called with text postfix > ? timeofday(7) 5.248 seconds
https://www.lianja.com/doc/index.php/TIMEOFDAY()
echo strftime("%c",ttoc(datetime())) echo strftime("%U",dtoc(date()))
https://www.lianja.com/doc/index.php/STRFTIME()
mdate = ctot("01/21/2004 01:44:44 PM") ? mdate 01/21/2004 01:44:44 PM ? type("mdate") T
https://www.lianja.com/doc/index.php/CTOT()
? stot("20121003101509") 10/03/2012 10:15:09 AM
https://www.lianja.com/doc/index.php/STOT()
? elaptime("10:10:10","11:11:11") 01:01:01
https://www.lianja.com/doc/index.php/ELAPTIME()
? hour({10/10/2004 10:15:43 AM}) 10 m_Hour = hour(datetime()) ? type("m_Hour") N
https://www.lianja.com/doc/index.php/HOUR()
? hours("10:00:00") 10
https://www.lianja.com/doc/index.php/HOURS()
? minute({10/10/2004 10:15:43 AM}) 15 m_Min = minute(datetime()) ? type("m_Min") N
https://www.lianja.com/doc/index.php/MINUTE()
? minutes("10:21:00") 21
https://www.lianja.com/doc/index.php/MINUTES()
? sec({10/10/2004 10:15:43 AM}) 43 m_Sec = sec(datetime()) ? type("m_Sec") N
https://www.lianja.com/doc/index.php/SEC()
? seconds("10:13:21") 38601 // From Lianja v2.0 ? seconds() 36834.470
https://www.lianja.com/doc/index.php/SECONDS()
? secs("10:10:10") 36610 // Another Example use accounts replace seconds with secs(time()) ? seconds 39306 ? tstring(seconds) 10:55:00
https://www.lianja.com/doc/index.php/SECS()
? time() 17:47:24 ? time(1) 17:47:31.00
https://www.lianja.com/doc/index.php/TIME()
update_time = timestamp()
https://www.lianja.com/doc/index.php/TIMESTAMP()
? tstring(36610) 10:10:10
https://www.lianja.com/doc/index.php/TSTRING()
set date american ? ttoc({^2004-03-29 10:15:43 AM}) 03/29/2004 10:15:43 AM ? ttoc({^2004-03-29 10:15:43 AM},1) 20040329101543 ? ttoc({^2004-03-29 10:15:43 AM},2) 10:15:43 AM ? ttoc({^2004-03-29 10:15:43 AM},3) 20040329 10:15:43 ? ttoc({^2004-03-29 10:15:43 AM},4) 2004-03-29T10:15:43.000Z
https://www.lianja.com/doc/index.php/TTOC()
set date american set century on mdate = ttod({^2004-03-29 10:15:43 AM}) ? mdate 03/29/2004 ? type("mdate") D
https://www.lianja.com/doc/index.php/TTOD()
set date american set century on mdate = dtot({03/29/2010}) ? mdate 03/29/2010 10:15:43 AM ? type("mdate") T
https://www.lianja.com/doc/index.php/DTOT()
store "00:00" to m_time @5,5 get m_time picture "99:99"; valid validtime(m->m_time+":00"); error "Invalid time. Press any key."; help "Enter the start time." read
https://www.lianja.com/doc/index.php/VALIDTIME()
? week(datetime()) ? week(date(),2)) ? week(date(),0,2) // Week starts on Sunday (default), first week has four days in current year ? week({01/01/2004},2) 53 // Week starts on Monday, first week has four days in current year ? week({01/01/2004},2,2) 1
https://www.lianja.com/doc/index.php/WEEK()
? cmonth(datetime()) October ? cmonth(date()) October store cmonth(date()) to month ? month October ? type("month") C
https://www.lianja.com/doc/index.php/CMONTH()
mdate = ctod("11/10/2003") ? mdate 11/10/2003 ? type("mdate") D
https://www.lianja.com/doc/index.php/CTOD()
? date() 04/04/2004 mdate = date() ? mdate 04/04/2004 ? type("mdate") D ? date(4,4,4) 04/04/2004
https://www.lianja.com/doc/index.php/DATE()
? datetime() 04/04/2004 11:54:45 AM mdatetime = datetime() ? mdatetime 04/04/2004 11:54:45 AM ? type("mdatetime") T ? datetime(4,4,4,4,4,4) 04/04/2004 04:04:04 AM ? datetime(4,4,4,14) 04/04/2004 02:00:00 PM
https://www.lianja.com/doc/index.php/DATETIME()
? day({01/01/2004}) 1 store day({01/01/2004}) to m_Day ? m_Day 1 m_Day = day(date()) ? type("m_Day") N ? day({10/10/2004 10:15:43 AM}) 10
https://www.lianja.com/doc/index.php/DAY()
? isleapyear(2012) .T.
https://www.lianja.com/doc/index.php/ISLEAPYEAR()
? leapyears(date()) 487 ? leapyears(datetime()) 487 ? leapyears(val(sys(1))) 487
https://www.lianja.com/doc/index.php/LEAPYEARS()
? days(300033) 3 m_secs=357812 ? "The period was "+alltrim(str(days(m->m_secs)))+; " days and "+tstring(m->m_secs) +" hours" The period was 4 days and 03:23:32 hours
https://www.lianja.com/doc/index.php/DAYS()
? dmy({04/04/2005}) 4 April 2005 ? dmy({04/04/2005 06:12:45 PM}) 4 April 2005
https://www.lianja.com/doc/index.php/DMY()
set date american ? dow({02/29/2004}) 1 ? dow({02/29/2004},2) 7 store dow({02/29/2004}) to dayofweek ? dayofweek 1 dayofweek = dow({02/29/2004 11:35:27 A.M.}) ? dayofweek
https://www.lianja.com/doc/index.php/DOW()
? dtoc({02/29/2004}) 02/29/2004 ? dtoc({02/29/2004 10:34:21 A.M.}) 02/29/2004 ? dtoc({02/29/2004},1) 20040229 store dtoc({02/29/2004}) to m_date ? m_date 02/29/2004 ? type("m_date") C
https://www.lianja.com/doc/index.php/DTOC()
? dtom({10/10/2000}) 10-Oct-2000
https://www.lianja.com/doc/index.php/DTOM()
? dtos({02/29/2004}) 20040229 ? dtos({02/29/2004 11:18:54 PM}) 20040229 store dtos({02/29/2004})to m_date ? m_date 20040229 ? type("m_date") C
https://www.lianja.com/doc/index.php/DTOS()
? dtov({02/02/2000}+7) 9-FEB-2000 00:00:00.00
https://www.lianja.com/doc/index.php/DTOV()
? epoch() 1900 set epoch to 1995 ? epoch() 1995
https://www.lianja.com/doc/index.php/EPOCH()
?gomonth({04/14/2004}, 4) 08/14/2004 ? gomonth({01/21/2004 03:18:33 PM},-12) 01/21/2003
https://www.lianja.com/doc/index.php/GOMONTH()
set century on ? mdy({04/04/1990}) April 4, 1990
https://www.lianja.com/doc/index.php/MDY()
? month(date()) 10 ? month(datetime()) 10
https://www.lianja.com/doc/index.php/MONTH()
set century on ? mtod("10-Oct-2008") 10/10/2008
https://www.lianja.com/doc/index.php/MTOD()
? quarter({01/22/2004}) 1 ? quarter({^20040822 12:34:29 PM}) 3 ? quarter({01/22/2004},2) 4
https://www.lianja.com/doc/index.php/QUARTER()
mCdate = dtos(date()) ? mCdate 20130722 ? type("mCdate") C mDdate = stod(mCdate) ? mDdate 07/22/2013 ? type("mDdate") D
https://www.lianja.com/doc/index.php/STOD()
? vtod("17-MAY-1990")+7 05/24/1990
https://www.lianja.com/doc/index.php/VTOD()
? date() 04/04/2004 ? year(date()) 2004 ? year(datetime()) 2004
https://www.lianja.com/doc/index.php/YEAR()
> ? is_date(date()) .T. > ? is_date({12/12/2010}) .T.
https://www.lianja.com/doc/index.php/IS_DATE()