~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_time.result

MergeĀ inĀ trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
408
408
unix_timestamp(from_unixtime(2147483648))
409
409
NULL
410
410
select unix_timestamp('2039-01-20 01:00:00');
411
 
ERROR HY000: Received an invalid value '2039-01-20 01:00:00' for a UNIX timestamp.
 
411
unix_timestamp('2039-01-20 01:00:00')
 
412
2179098000
412
413
select unix_timestamp('1968-01-20 01:00:00');
413
414
ERROR HY000: Received an invalid value '1968-01-20 01:00:00' for a UNIX timestamp.
414
415
select unix_timestamp('2038-02-10 01:00:00');
415
 
ERROR HY000: Received an invalid value '2038-02-10 01:00:00' for a UNIX timestamp.
 
416
unix_timestamp('2038-02-10 01:00:00')
 
417
2149376400
416
418
select unix_timestamp('1969-11-20 01:00:00');
417
419
ERROR HY000: Received an invalid value '1969-11-20 01:00:00' for a UNIX timestamp.
418
420
select unix_timestamp('2038-01-20 01:00:00');
419
 
ERROR HY000: Received an invalid value '2038-01-20 01:00:00' for a UNIX timestamp.
 
421
unix_timestamp('2038-01-20 01:00:00')
 
422
2147562000
420
423
select unix_timestamp('1969-12-30 01:00:00');
421
424
ERROR HY000: Received an invalid value '1969-12-30 01:00:00' for a UNIX timestamp.
422
425
select unix_timestamp('2038-01-17 12:00:00');