Toad World® Forums

date variable

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.com

That 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

He said he wanted file name as part of “toad apps” meaning the app
designer – and there is a simple way to do this. Right hand mouse in the
field and select the variables at the bottom as shown here: