Re: Inserting time value into table

[Mike Morgan <MMorgan@MELLONINVESTOR.COM>]

I'm curious about Convoy...where did you get it?

-----Original Message-----
From: AM Matula [mailto:amatula@OIT.UMASS.EDU]
Sent: Thursday, May 17, 2001 2:28 PM
To: SQR-USERS@list.iex.net
Subject: Inserting time value into table


Hi all

A coworker working on a Convoy project (Convoy creates SQRs) needs to insert
a time value (such as 09:15) into a PS table with a variable type of TIME

In the past I have done this within the SQL statement using the TO_DATE
function.

Convoy unfortunately cannot do this, at least not easily (that I am aware of
anyway!)

I thought I could use PS's "Convert to date" functions in datetime.sqc but I
haven't one that is applicable.

I tried a manaul test assigning a value of '01-JAN-1900_11:15:00_AM' to a
date variable declared using DECLARE-VARIABLE and then inserting into the
field.  I thought this was native format that but received a message this
wasn't in an acceptable format:

ORA-01830: date format picture ends before converting entire input string

However if I use '01-JAN-1900' that works!

Any suggestions on how to get time value inserted without needing to use
TO_DATE in the SQL statement?



I receive this in digest format so if you can cc me in on any responses, I'd
greatly appreciate it!

Have a great day!
Anne-Marie


-- - -- - -- - -- - -- - -- - -- - -- - -- - -- - --
Anne-Marie Matula
Student Information System Project
Office of Information Technologies
University of Massachusetts
740 N. Pleasant St
OIT-LGRC A247
Amherst, MA  01003-9306
Phone: 413/577-0685
Fax: 413/545-2150
`
**************************************************************
NOTICE: The information contained in this e-mail is confidential and may be
privileged or otherwise protected from disclosure.  This e-mail is intended
solely for the use of the named addressee.  Please be aware that any other
use, printing, copying, disclosure or dissemination may be subject to legal
restriction.  If you are not the intended recipient, please notify us
immediately by return e-mail to the sender.