How do I add a date stamp variable to TOAD for Oracle (10.5)?
I use several applications that require a certain format - MMDDYYYYhhmm.
How can I add this to a filename in TOAD Apps?
(the code select substr(to_char(sysdate,‘mm/dd/yyyy hh:mm’),1,2) ||
substr(to_char(sysdate,‘mm/dd/yyyy hh:mm’),4,2) ||
substr(to_char(sysdate,‘mm/dd/yyyy hh:mm’),7,4) ||
substr(to_char(sysdate,‘mm/dd/yyyy hh:mm’),12,2) ||
substr(to_char(sysdate,‘mm/dd/yyyy hh:mm’),15,2)
from dual
will produce the correct string.)
I give up! Fortunately, I found several work-arounds
Why not simple?
SELECT to_char(SYSDATE,‘MMDDYYYYhh24mm’)FROM DUAL
On Fri, Jun 24, 2011 at 3:28 PM, jneilson_609
wrote:
Message from: jneilson_609
I give up! Fortunately, I found several work-arounds
_______________________________________
Historical Messages
Author: jneilson_609
Date: Fri Jun 24 06:28:52 PDT 2011
I give up! Fortunately, I found several work-arounds
__
Author: jneilson_609
Date: Thu Dec 16 14:26:42 PST 2010
How do I add a date stamp variable to TOAD for Oracle (10.5)?
I use several applications that require a certain format - MMDDYYYYhhmm.
How can I add this to a filename in TOAD Apps?
(the code select substr(to_char(sysdate,'mm/dd/yyyy hh:mm'),1,2) ||
substr(to_char(sysdate,'mm/dd/yyyy hh:mm'),4,2) ||
substr(to_char(sysdate,'mm/dd/yyyy hh:mm'),7,4) ||
substr(to_char(sysdate,'mm/dd/yyyy hh:mm'),12,2) ||
substr(to_char(sysdate,'mm/dd/yyyy hh:mm'),15,2)
from dual
will produce the correct string.)
__
_______________________________________
–
Regards, Met Vriendelijke Groeten
Rob Zijlstra
www.zijlstra.smugmug.comThat should be “hh24mi”, not “mm” (unless you really want the month). But aside
from that it should work. I make that mm/mi mistake all the time.
– jim
