Oracle date time literals - Revision history

Brianegge at 05:25, 15 July 2009

2009-07-15T05:25:58Z

@@ Line 9: / Line 9: @@
 select * from WORK_LOG where start_time > to_date('01/07/2009','DD/MM/YYYY') order by start_time;
 </geshi>
 [[Category:Oracle]]

Brianegge at 01:14, 15 July 2009

2009-07-15T01:14:09Z

← Older revision		Revision as of 01:14, 15 July 2009
Line 8:		Line 8:
	select * from WORK_LOG where start_time > TIMESTAMP'2009-07-01 0:0:0' order by start_time;		select * from WORK_LOG where start_time > TIMESTAMP'2009-07-01 0:0:0' order by start_time;
	select * from WORK_LOG where start_time > to_date('01/07/2009','DD/MM/YYYY') order by start_time;		select * from WORK_LOG where start_time > to_date('01/07/2009','DD/MM/YYYY') order by start_time;
	<geshi>		</geshi>

	[[Category:Oracle]]		[[Category:Oracle]]

Brianegge: Created page with 'Every RDBMS has it's own format for specifying dates, times, and time stamp literals. When writing adhoc queries it's easiest if you can directly type in a date in the format th…'

2009-07-15T01:12:58Z

Created page with 'Every RDBMS has it's own format for specifying dates, times, and time stamp literals. When writing adhoc queries it's easiest if you can directly type in a date in the format th…'

New page

Every RDBMS has it's own format for specifying dates, times, and time stamp literals. When writing adhoc queries it's easiest if you can directly type in a date in the format that the database expects, without having to resort to a cast. When writing code, one should attempt to avoid converting times to and from string representation.

The following all are valid for comparisons against a date field.

<geshi lang="sql">
select * from WORK_LOG where start_time > TIMESTAMP'2009-07-01 00:00:00.000' order by start_time;
select * from WORK_LOG where start_time > TIMESTAMP'2009-07-01 00:00:00' order by start_time;
select * from WORK_LOG where start_time > TIMESTAMP'2009-07-01 0:0:0' order by start_time;
select * from WORK_LOG where start_time > to_date('01/07/2009','DD/MM/YYYY') order by start_time;
<geshi>

[[Category:Oracle]]