RE: Negative/BC/BCE time
John Dorlon <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <4120B436C765EC43A31CC3E2A13D36A62270AE88@ALVMBXW02.prod.quest.corp> |
I was just playing with this in Delphi. I found a way to get A.D. in front of dates, but when I throw a date at it before 1/1/0001, it doesn't show BC or AD. I don't think you should rely on Toad to show you anything before 1/1/0001 in date format. You should us TO_CHAR in your queries if you expect anything before that. From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Saturday, July 21, 2012 2:59 PM To: [email protected] Subject: [toad] Negative/BC/BCE time Can we get an option to display the sign for years or BC/AD or BCE/CE options in time formats? It's not often that I'm storing negative years, but when I do, it's quite confusing to not be able to tell the difference between 1000 BC and 1000 AD without converting to a string.