← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/timezone.result

  • Committer: Brian Aker
  • Date: 2008-12-19 22:43:03 UTC
  • mfrom: (642.1.42 drizzle-clean-code)
  • Revision ID: brian@tangent.org-20081219224303-wr3j30ej9vjr7el0
Merging for Lee.

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'),