~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/timezone.result

  • Committer: Brian Aker
  • Date: 2011-01-19 18:03:32 UTC
  • mfrom: (2088.8.12 timestamp)
  • mto: This revision was merged to the branch mainline in revision 2098.
  • Revision ID: brian@tangent.org-20110119180332-acfk5i8oofp63s40
Merge in time code.

Show diffs side-by-side

added added

removed removed

Lines of Context:
3
3
DROP TABLE IF EXISTS t1;
4
4
select @a:=FROM_UNIXTIME(1);
5
5
@a:=FROM_UNIXTIME(1)
6
 
1970-01-01 00:00:01
 
6
1970-01-01 00:00:01.000000
7
7
select unix_timestamp(@a);
8
8
unix_timestamp(@a)
9
9
1
45
45
unix_timestamp('2038-01-19 03:14:07')
46
46
2147483647
47
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.
 
48
unix_timestamp('2038-01-19 03:14:08')
 
49
2147483648