diff options
| author | Paul McCullagh <paul.mccullagh@primebase.org> | 2009-04-02 12:03:14 +0200 |
|---|---|---|
| committer | Paul McCullagh <paul.mccullagh@primebase.org> | 2009-04-02 12:03:14 +0200 |
| commit | 5f513d0941d9d8baa6875a42afea4dfb8ec7f586 (patch) | |
| tree | f6290400046f8f4f51857f4ed04aa17d3d1f272b /mysql-test/suite/pbxt/r/func_timestamp.result | |
| parent | e1e48d82d426d1a076bcdaf60f2e23470d8ecb01 (diff) | |
| download | mariadb-git-5f513d0941d9d8baa6875a42afea4dfb8ec7f586.tar.gz | |
Added the PBXT test suite
Diffstat (limited to 'mysql-test/suite/pbxt/r/func_timestamp.result')
| -rw-r--r-- | mysql-test/suite/pbxt/r/func_timestamp.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/suite/pbxt/r/func_timestamp.result b/mysql-test/suite/pbxt/r/func_timestamp.result new file mode 100644 index 00000000000..495fedea9e6 --- /dev/null +++ b/mysql-test/suite/pbxt/r/func_timestamp.result @@ -0,0 +1,13 @@ +drop table if exists t1; +set time_zone="+03:00"; +create table t1 (Zeit time, Tag tinyint not null, Monat tinyint not null, +Jahr smallint not null, index(Tag), index(Monat), index(Jahr) ); +insert into t1 values ("09:26:00",16,9,1998),("09:26:00",16,9,1998); +SELECT CONCAT(Jahr,'-',Monat,'-',Tag,' ',Zeit) AS Date, +UNIX_TIMESTAMP(CONCAT(Jahr,'-',Monat,'-',Tag,' ',Zeit)) AS Unix +FROM t1; +Date Unix +1998-9-16 09:26:00 905927160 +1998-9-16 09:26:00 905927160 +drop table t1; +set time_zone= @@global.time_zone; |