← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/date_formats.result

  • Committer: Brian Aker
  • Date: 2009-02-04 18:28:00 UTC
  • mfrom: (813.1.26 new-temporal)
  • Revision ID: brian@tangent.org-20090204182800-ra3p8rlu4zrs9fvn
Merge from Monty.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/date_formats.result
496
496
select str_to_date("2003-01-02 10:11:12.0012ABCD", "%Y-%m-%d %H:%i:%S.%f") as f1,
497
497
addtime("-01:01:01.01 GGG", "-23:59:59.1") as f2,
498
498
microsecond("1997-12-31 23:59:59.01XXXX") as f3;
499
 
f1      f2      f3
500
 
2003-01-02 10:11:12.001200      -25:01:00.110000        10000
501
 
Warnings:
502
 
Warning 1292    Truncated incorrect datetime value: '2003-01-02 10:11:12.0012ABCD'
503
 
Warning 1292    Truncated incorrect time value: '-01:01:01.01 GGG'
504
 
Warning 1292    Truncated incorrect time value: '1997-12-31 23:59:59.01XXXX'
 
499
ERROR HY000: Received an invalid datetime value '1997-12-31 23:59:59.01XXXX'.
505
500
select str_to_date("2003-04-05  g", "%Y-%m-%d") as f1,
506
501
str_to_date("2003-04-05 10:11:12.101010234567", "%Y-%m-%d %H:%i:%S.%f") as f2;
507
502
f1      f2