Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: natachatecgraf
- Order by date
-
Date format in oracle/sql
I am working in ORACLE. Because the datetime always have the parts of the time and the date, I ask: There are any way to know which format was used to insert the data?- natachatecgraf
- Post #11
- Forum: Oracle: All versions
-
Date format in oracle/sql
SantaMufasa: I am facing the same situation described on the thread number 181-27567. Unfortunately the solution you have suggested : select to_char(sysdate,'hh24:mi')Time,to_char(sysdate,'dd/mm/yy')Date_ from dual; does *not* solve my problem as I have no way to know , before hand, if the...- natachatecgraf
- Post #9
- Forum: Oracle: All versions
