Adding seconds to a Time Stamp
select current_time, current_time + interval '02' second;
posted by Ranjith at
10:13 am
Wednesday, December 17, 2008
About Me
- Name: Ranjith
- Location: Sydney, New South Wales, Australia
I too find that the harder I work, the more luck I seem to have.
Previous Posts
- Statistics - Unique Values
- Statistics - All About
- Data Skew Check
- Casespecific TD Environment
- Is XX a reserved word ??
- Find PI Statistics
- Running Updatespace Utility
- Running Ferret thro CNSRUN
- Releasing User lock on DBC
- Inserting NewLine char !!
Subscribe to
Posts [Atom]
1 Comments:
I'd rather use:
select current_time, current_time + cast( 2 as interval second );
Post a Comment
Subscribe to Post Comments [Atom]
<< Home