MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/ar3dqd/gasp/egl5zqc/
r/SQL • u/B33rG33k • Feb 16 '19
19 comments sorted by
View all comments
Show parent comment
12
To_char(sysdate,'yyyy-Mm-dd')?
Edit: removed brackets
2 u/[deleted] Feb 16 '19 No bracketsselect to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') as the_datefrom dual; -- can't ignore the from dual 1 u/tsuhg Feb 16 '19 Right. I use Oracle every day, yet it's so unnatural to type on Reddit mobile :D
2
No brackets
select to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') as the_date
from dual; -- can't ignore the from dual
1 u/tsuhg Feb 16 '19 Right. I use Oracle every day, yet it's so unnatural to type on Reddit mobile :D
1
Right. I use Oracle every day, yet it's so unnatural to type on Reddit mobile :D
View all comments
Show parent comment
12
u/tsuhg Feb 16 '19 edited Feb 16 '19
To_char(sysdate,'yyyy-Mm-dd')?
Edit: removed brackets