Posted by Grant Foraker on September 22, 2010 at 13:11:38:
In Reply to: a "hack" for creating "Oracle Date Formats" such as 04-JUL-1776 posted by Bob A on September 22, 2010 at 12:39:56:
Always thought that was a military style date. But, Oracle takes credit for everything now :)
I'd do it like so ...
DATE2NUM
NUM2DATE - option 5
getting ...
Day, DD Mon YYYY HH:MM:SS -nnnn -mmmm
Then SUB and concatenate to get DD-MON-YY or "DDMONYY"
Is this a date variation that could/Sshould be added to NUM2DATE and DATE2NUM?
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.