← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_time.result

  • Committer: Jay Pipes
  • Date: 2009-03-01 03:08:20 UTC
  • mto: (910.2.6 mordred-noatomics)
  • mto: This revision was merged to the branch mainline in revision 912.
  • Revision ID: jpipes@serialcoder-20090301030820-8kxgypvo3yexa9d1
Final removal of timezones

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/func_time.result
657
657
select last_day("1997-12-1")+0.0;
658
658
last_day("1997-12-1")+0.0
659
659
19971231.0
660
 
select strcmp(date_sub(localtimestamp(), interval 3 hour), utc_timestamp())=0;
661
 
strcmp(date_sub(localtimestamp(), interval 3 hour), utc_timestamp())=0
662
 
0
663
 
select strcmp(date_format(date_sub(localtimestamp(), interval 3 hour),"%Y-%m-%d"), utc_date())=0;
664
 
strcmp(date_format(date_sub(localtimestamp(), interval 3 hour),"%Y-%m-%d"), utc_date())=0
 
660
select strcmp(date_sub(localtimestamp(), interval 0 hour), utc_timestamp())=0;
 
661
strcmp(date_sub(localtimestamp(), interval 0 hour), utc_timestamp())=0
 
662
1
 
663
select strcmp(date_format(date_sub(localtimestamp(), interval 0 hour),"%Y-%m-%d"), utc_date())=0;
 
664
strcmp(date_format(date_sub(localtimestamp(), interval 0 hour),"%Y-%m-%d"), utc_date())=0
665
665
1
666
666
select strcmp(date_format(utc_timestamp(),"%Y-%m-%d"), utc_date())=0;
667
667
strcmp(date_format(utc_timestamp(),"%Y-%m-%d"), utc_date())=0