Forums before death by AOL, social media and spammers... "We can't have nice things"
| comp.databases.oracle | Overblown overpriced overengineered SHIT | 2,288 messages |
[ << oldest | < older | list | newer > | newest >> ]
| Message 2,061 of 2,288 |
| Bob to All |
| Convert timestamp to date |
| 29 Mar 05 19:41:12 |
From: no@mail.com Trying to convert timestamp data to date data (without the time in hours/mins/secs), does only seem to work with TO_DATE(mydate; 'yyyymmdd'). But I do not want a string, but a real date like 29-03-2005. How do I get it like that? Thanks, Bob --- SoupGate-Win32 v1.05 * Origin: you cannot sedate... all the things you hate (1:229/2) |
(c) 1994, bbs@darkrealms.ca