Re: SQL: convert common format mm/dd/yyyy (with slashes) text to DATETIME stamp

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Are you on 7.1?
timestamp_format('1/2/2014','MM/DD/YYYY')

Charles




On Fri, Sep 12, 2014 at 3:01 PM, Stone, Joel <Joel.Stone@xxxxxxxxxx> wrote:

> Is there a simpler method to accomplish?
>
> Hopefully simpler than:
>
> timestamp(substr(DATEMMDDYYYY,6,4)||'-'||substr(DATEMMDDYYYY,1,1)
> ||'-'||substr(DATEMMDDYYYY,3,2)||'-00.00.00.000000')
>
> The above works for a single digit month (January thru September 1 thru 9).
>
> For the 2 digit months, the above must be altered so it gets even messier.
>
> And again for 1 or 2 digit days (1-9 vs 10-31)
>
> Is there a nice easy short & simple way to accomplish m/d/yyyy or
> mm/d/yyyy or m/dd/yyyy or mm/dd/yyyy to TIMESTAMP in SQL?
>
> Thanks!
>
>
>
> ______________________________________________________________________
> This outbound email has been scanned for all viruses by the MessageLabs
> Skyscan service.
> For more information please visit http://www.symanteccloud.com
> ______________________________________________________________________
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.