date.sql.out

关系型数据库 Postgresql 6.5.2

QUERY: create table dd (d date);
QUERY: insert into dd values ('06-22-1995');
QUERY: insert into dd values ('05-31-1994');
QUERY: insert into dd values ('02-29-1996');
QUERY: insert into dd values ('12-02-1993');
QUERY: insert into dd values ('05-31-1994');
QUERY: insert into dd values ('10-20-1970');
QUERY: select * from dd;
d           
----------- 
06-22-1995  
05-31-1994  
02-29-1996  
12-02-1993  
05-31-1994  
10-20-1970  
QUERY: select * from dd order by d;
d           
----------- 
10-20-1970  
12-02-1993  
05-31-1994  
05-31-1994  
06-22-1995  
02-29-1996  
QUERY: select * from dd order by d using >;
d           
----------- 
02-29-1996  
06-22-1995  
05-31-1994  
05-31-1994  
12-02-1993  
10-20-1970  
QUERY: select * from dd where d = '05-31-1994';
d           
----------- 
05-31-1994  
05-31-1994  
QUERY: select * from dd where d <> '05-31-1994';
d           
----------- 
06-22-1995  
02-29-1996  
12-02-1993  
10-20-1970  
QUERY: select * from dd where d < '05-31-1994';
d           
----------- 
12-02-1993  
10-20-1970  
QUERY: select * from dd where d <= '05-31-1994';
d           
----------- 
05-31-1994  
12-02-1993  
05-31-1994  
10-20-1970  
QUERY: select * from dd where d > '05-31-1994';
d           
----------- 
06-22-1995  
02-29-1996  
QUERY: select * from dd where d >= '05-31-1994';
d           
----------- 
06-22-1995  
05-31-1994  
02-29-1996  
05-31-1994  
QUERY: create index dd_ind on dd using btree (d date_ops);
QUERY: drop table dd;