← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/timezone.result

  • Committer: Monty Taylor
  • Date: 2009-03-05 02:06:48 UTC
  • mfrom: (907.1.8 trunk-with-temporal)
  • mto: This revision was merged to the branch mainline in revision 912.
  • Revision ID: mordred@inaugust.com-20090305020648-7jk1gie4lqsi22g8
Merged from Jay.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/timezone.result
1
1
FROM_UNIXTIME(24*3600)
2
 
1970-01-02 01:00:00
 
2
1970-01-02 00:00:00
3
3
DROP TABLE IF EXISTS t1;
4
 
show variables like "system_time_zone";
5
 
Variable_name   Value
6
 
system_time_zone        MET
7
4
select @a:=FROM_UNIXTIME(1);
8
5
@a:=FROM_UNIXTIME(1)
9
 
1970-01-01 01:00:01
 
6
1970-01-01 00:00:01
10
7
select unix_timestamp(@a);
11
8
unix_timestamp(@a)
12
9
1
23
20
INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 04:00:01'));
24
21
SELECT ts,from_unixtime(ts) FROM t1;
25
22
ts      from_unixtime(ts)
26
 
1035673200      2002-10-27 01:00:00
27
 
1035680400      2002-10-27 02:00:00
28
 
1035684000      2002-10-27 03:00:00
29
 
1035680400      2002-10-27 02:00:00
30
 
1035673200      2002-10-27 01:00:00
31
 
1035680400      2002-10-27 02:00:00
32
 
1048986000      2003-03-30 03:00:00
33
 
1048986000      2003-03-30 03:00:00
34
 
1048989599      2003-03-30 03:59:59
35
 
1048989601      2003-03-30 04:00:01
 
23
1035680400      2002-10-27 01:00:00
 
24
1035684000      2002-10-27 02:00:00
 
25
1035687600      2002-10-27 03:00:00
 
26
1035684000      2002-10-27 02:00:00
 
27
1035680400      2002-10-27 01:00:00
 
28
1035684000      2002-10-27 02:00:00
 
29
1048993199      2003-03-30 02:59:59
 
30
1048993200      2003-03-30 03:00:00
 
31
1048996799      2003-03-30 03:59:59
 
32
1048996801      2003-03-30 04:00:01
36
33
DROP TABLE t1;
37
34
CREATE TABLE t1 (ts timestamp);
38
35
INSERT INTO t1 (ts) VALUES ('2003-03-30 01:59:59'),
39
36
('2003-03-30 03:00:00');
40
37
DROP TABLE t1;
41
 
select unix_timestamp('1970-01-01 01:00:00'), 
42
 
unix_timestamp('1970-01-01 01:00:01'),
43
 
unix_timestamp('2038-01-19 04:14:07'),
44
 
unix_timestamp('2038-01-19 04:14:08');
45
 
unix_timestamp('1970-01-01 01:00:00')   unix_timestamp('1970-01-01 01:00:01')   unix_timestamp('2038-01-19 04:14:07')   unix_timestamp('2038-01-19 04:14:08')
46
 
0       1       2147483647      0
 
38
select unix_timestamp('1970-01-01 00:00:00');
 
39
unix_timestamp('1970-01-01 00:00:00')
 
40
0
 
41
select unix_timestamp('1970-01-01 00:00:01');
 
42
unix_timestamp('1970-01-01 00:00:01')
 
43
1
 
44
select unix_timestamp('2038-01-19 03:14:07');
 
45
unix_timestamp('2038-01-19 03:14:07')
 
46
2147483647
 
47
select unix_timestamp('2038-01-19 03:14:08');
 
48
ERROR HY000: Received an invalid value '2038-01-19 03:14:08' for a UNIX timestamp.