← 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: 2008-12-21 04:16:39 UTC
  • mfrom: (726 testable)
  • mto: (722.2.2 devel)
  • mto: This revision was merged to the branch mainline in revision 727.
  • Revision ID: monty@inaugust.com-20081221041639-u1d19wdrq70s5qug
Merged from trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/timezone.result
 
1
FROM_UNIXTIME(24*3600)
 
2
1970-01-02 01:00:00
1
3
DROP TABLE IF EXISTS t1;
2
4
show variables like "system_time_zone";
3
5
Variable_name   Value
34
36
DROP TABLE t1;
35
37
CREATE TABLE t1 (ts timestamp);
36
38
INSERT INTO t1 (ts) VALUES ('2003-03-30 01:59:59'),
37
 
('2003-03-30 02:59:59'),
38
39
('2003-03-30 03:00:00');
39
 
Warnings:
40
 
Warning 1299    Invalid TIMESTAMP value in column 'ts' at row 2
41
40
DROP TABLE t1;
42
41
select unix_timestamp('1970-01-01 01:00:00'), 
43
42
unix_timestamp('1970-01-01 01:00:01'),