~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/func_timestamp.test

• browse files at revision 511.2.1
• compare with another revision
• download diff
• download tarball
• view history from revision 511.2.1

• reverse the comparison (511.2.1 to 172)
• stop comparing with revision 172

Show diffs side-by-side

added

removed

tests/t/func_timestamp.test

9

9

# Set timezone to GMT-3, to make it possible to use "interval 3 hour"

10

10

set time_zone="+03:00";

11

11

 

12

 

create table t1 (Zeit time, Tag tinyint not null, Monat tinyint not null,

13

 

Jahr smallint not null, index(Tag), index(Monat), index(Jahr) );

 

12

create table t1 (Zeit time, Tag int not null, Monat int not null,

 

13

Jahr int not null, index(Tag), index(Monat), index(Jahr) );

14

14

insert into t1 values ("09:26:00",16,9,1998),("09:26:00",16,9,1998);

15

15

SELECT CONCAT(Jahr,'-',Monat,'-',Tag,' ',Zeit) AS Date,

16

16

   UNIX_TIMESTAMP(CONCAT(Jahr,'-',Monat,'-',Tag,' ',Zeit)) AS Unix

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1