Mike,
One warning if you are going to mess with date and time formats.
You need to be the only person on the system for the duration
of you process as the canges affets all signed on. This could
have serious unfavorable consequences to any forms that accept
date input.l
If you check my postings to this thread, it indeed can be done
in one statement.
Jim Bentley
--- MikeB <[EMAIL PROTECTED]> wrote:
> OK, here is the simple way in one go...
>
>
>
> {
> Control via the Date Time Format Seq to match the input
> Don't mess with functions, they won't convert in one go to
> DateTime
>
> temp table StWills has Three cols:
> One Date and One Time one Computed to DateTime
> }
>
> SET DATE FORMAT DD-MMM-YYYY
> SET DATE SEQUENCE ddmmyyyy
> SET TIME FORMAT HH:MM:SS AP
> SET TIME SEQUENCE hhmmss
> SET VAR vstr = '03-Oct-2007 01:23:38 PM'
> INSERT INTO stwills coldate, coltime SELECT
> (SGET(.vstr,11,1)),
> (SGET(.vstr,11,13)) FROM dummy
>
>
> RETURN
>
>
>
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
