Dude, the month is 09! Try mm. |
|
Hey all. So I'm running this query in SQL developer on an Oracle DB. |
|
Dude, the month is 09! Try mm. |
|
Ahh yes. I love feeling stupid. Actually since it was Oracle (not sql) had to change it to MI. Thanks coder |
|
Sure. I will be here all week. |
|
mm is minute, MM is month. SS isn't seconds either, it's ss. |
|
Yeah, MI is minute. SS(capital) actually does give you seconds. I usually to 'YYYY-MM-DD HH24:MI:SS' though would be easier to just set that as the default then you never need to format to_char by hand. |
|
Bookmarks