Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Trininole
Yak Posting Veteran
83 Posts |
 Posted - 2012-08-13 : 11:01:13
|
| How would i write the date format in Oracle using the dates betweenJune 6, 2012 and August 1, 2012??Roger DeFour |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2012-08-13 : 11:15:20
|
| Sorry, but these are Microsoft SQL Server specific forums. In SQL Server,SELECT * FROM yourTable WHERE MyDate BETWEEN '6/6/2012' AND '8/1/2012'--------------------------http://connectsql.blogspot.com/ |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-08-13 : 11:15:42
|
| It would be better to ask on an Oracle forum: http://dbforums.com/SQLTeam is a Microsoft SQL Server website. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2012-08-16 : 08:43:14
|
quote:
Originally posted by Trininole
How would i write the date format in Oracle using the dates betweenJune 6, 2012 and August 1, 2012??Roger DeFour
Oracle's default format is DD-MON-YYYY. So just input the dates in that formatMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Date format in Oracle