-------------
2008-02-02
_____________________
SELECT ADDTIME('2007-12-31 23:59:59.999999', '1 1:1:1.000002');
1 dienas; 1 stundas plus;
--------------------
2008-01-02 01:01:01.000001
_____________________
SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET'); no laika joslas uz laika joslu;
SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','+02:00');
---------------
2004-01-01 14:00:00
_____________________
SELECT CURDATE();
---------------
2012-01-09
_____________________
SELECT CURDATE()+0;
---------------
20120109
_____________________
SELECT CURTIME();
---------------
12:44:30
_____________________
SELECT NOW();
---------------
2012-01-09 12:44:50
_____________________
SELECT NOW()+0; ----------20120109124512,000000________________________SELECT DATE('2003-12-31 01:02:03');
---------------
2003-12-31
____________________
SELECT DATEDIFF('2010-11-30 23:59:59','2010-12-31'); stundas neteik nemtas vērā;
----------------
-31
____________________
SELECT DATE_ADD('2008-01-02', INTERVAL 31 DAY);
---------------
2008-02-02
____________________
SELECT DATE_ADD('2008-01-02', INTERVAL 31 MICROSECOND);
---------------
2008-01-02 00:00:00.000031
____________________
MICROSECOND
SECOND
MINUTE
HOUR
DAY
WEEK
MONTH
QUARTER
YEAR
SECOND_MICROSECOND
SELECT DATE_ADD('2008-01-02', INTERVAL '31:32' SECOND_MICROSECOND); -------------2008-01-02 00:00:31.320000_____________________________
MINUTE_MICROSECOND
MINUTE_SECOND
HOUR_MICROSECOND
HOUR_SECOND
HOUR_MINUTE
DAY_MICROSECOND
DAY_SECOND
DAY_MINUTE
DAY_HOUR
SELECT DATE_ADD('2008-01-02 21:40:28.000000', INTERVAL '-3 1' DAY_HOUR);
---------------
2007-12-30 20:40:28
______________________________
YEAR_MONTH
_______________________________
SELECT DATE_FORMAT('2007-10-04 22:23:00', '%H:%i:%s');
-----------------
22:23:00
______________________
%a saisinats nedeļas dienas nosaukums sun, sat
%b saisināts men nosaukums jan.
%c skaitlisks mēnesis 0-12 bez nullem (1-12); var saturēt 0 mēnesi (dutums bez meneša)
%D meneša diena ar angļu sufiksu
%d mēneša diena 01-31 ar nullem
%e skaitliska mēneša diena 0-31
%f mikrosekundes
%H stunda 00-23 ar nulem
%h stunda 01-12
%I stunda 01-12
%i minutes skaitliski 00-59
%j gada diena 001-366 ar nulem
%k stundas 0-23 bez nullem
%l 1-12 stundas bez nullem
%M meneša nosaukums november
%m skaitlisks menesis 00-12
%p AM:PM
%r laiks 12 stundu formātā, stundas, minutes, sekundes, PM/AM
%S sekundes 0-59
%s sekundes 0-59
%T laiks 24 stundu formatā 03:55:15
%U nedeļas kārtas numurs, kur svētdiena ir pirma diena
%u normala nedeļas numurs, kur pirmdiena ir sakums;
%V 01-53 nedeļas numurs. svetdiena ir pirma diena
%v 01-53 pirmdiena ir pirma diena
%W nedeļas dienas nosaukums, satday
%w nedaļas dienas numurus 0-svetdiena;
%X
%x
%Y gads skailisks
%y gads skaitlisks 2 skaitļi
%% simbols%
__________________________
SELECT DAYNAME('2007-02-03'); dienas nosaukumu
SELECT DAYOFMONTH('2007-02-03'); mēneša dienu 1-31 vai 0, ja nav noradīts
SELECT DAYOFWEEK('2007-02-03'); nedeļas dienas kārtas numuru, 1 - svetdiena
SELECT DAYOFYEAR('2007-02-03'); gada dienu 1-366
SELECT EXTRACT(YEAR FROM '2009-07-02'); parada no mainīga informāciju
SELECT FROM_DAYS(378);
-----------------
0001-01-13
__________________________
SELECT FROM_UNIXTIME(1196440219);
----------------
2007-11-30 18:30:19
__________________________
SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(), '%Y %D %M %h:%i:%s');
----------------
2012 9th January 01:27:18
__________________________
SELECT UNIX_TIMESTAMP();
-----------------
1326108486
__________________________
SELECT UNIX_TIMESTAMP('2007-11-30 10:30:19');
-----------------
1196411419
__________________________
SELECT HOUR('10:05:03');
----------------
10
__________________________
GET_FORMAT({DATE|TIME|DATETIME}, {'EUR'|'USA'|'JIS'|'ISO'|'INTERNAL'})
SELECT GET_FORMAT(DATE,'USA');
------------------
%m.%d.%Y
__________________________
SELECT GET_FORMAT(TIME,'EUR'); ------------------
%H.%i.%s
_________________________
Комментариев нет:
Отправить комментарий