Saturday, June 20, 2009

DB2 Timestamp

SELECT STATEMENT:
select count(*) from customer where timestamp >='2010-01-01-00.00.00';

UPDATE (OR) INSERT STATEMENT:
update customer set timestamp=('2011-01-01-00.00.01.000000') where timestamp='2010-01-01-00.00.00';

No comments: