← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_timestamp.result

  • Committer: Brian Aker
  • Date: 2008-10-12 01:59:02 UTC
  • Revision ID: brian@tangent.org-20081012015902-prhy6wsimdqr28om
Dead code around unsigned (first pass)

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/func_timestamp.result
1
 
drop table if exists t1;
2
 
create table t1 (Tag int not null, Monat int not null,
3
 
Jahr int not null, index(Tag), index(Monat), index(Jahr) );
4
 
insert into t1 values (16,9,1998),(16,9,1998);
5
 
SELECT CONCAT(Jahr,'-',Monat,'-',Tag) AS Date,
6
 
UNIX_TIMESTAMP(CONCAT(Jahr,'-',Monat,'-',Tag)) AS Unix
7
 
FROM t1;
8
 
Date    Unix
9
 
1998-9-16       905904000
10
 
1998-9-16       905904000
11
 
drop table t1;