← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_time.result

  • Committer: Brian Aker
  • Date: 2009-02-18 01:52:47 UTC
  • mfrom: (873.2.35 devel)
  • Revision ID: brian@tangent.org-20090218015247-1hjai6kkwuife5zs
Merge Monty

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/func_time.result
665
665
from_days(to_days("960101")) as b;
666
666
describe t1;
667
667
Field   Type    Null    Key     Default Extra
668
 
a       date    NO              NULL    
 
668
a       date    NO              0000-00-00      
669
669
b       date    YES             NULL    
670
670
select * from t1;
671
671
a       b
784
784
show create table t1;
785
785
Table   Create Table
786
786
t1      CREATE TABLE `t1` (
787
 
  `now() - now()` double(23,6),
788
 
  `curtime() - curtime()` double(23,6),
789
 
  `sec_to_time(1) + 0` double(23,6),
790
 
  `from_unixtime(1) + 0` double(23,6)
 
787
  `now() - now()` double(23,6) DEFAULT NULL,
 
788
  `curtime() - curtime()` double(23,6) DEFAULT NULL,
 
789
  `sec_to_time(1) + 0` double(23,6) DEFAULT NULL,
 
790
  `from_unixtime(1) + 0` double(23,6) DEFAULT NULL
791
791
) ENGINE=InnoDB
792
792
drop table t1;
793
793
SELECT SEC_TO_TIME(3300000);