This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C0038B.D2275F00
Content-Type: text/plain;
charset="iso-8859-1"
I found this query to return the date W/ a time value in Oracle in the
forums. This seems to be the only way to get it to retrieve a time value
for me:
<cfquery name="Get_DT" datasource="My_DS">
select to_char(SYSDATE, 'DD-MM-YYYY HH24:MI:SS') LAST_UPDATE
from DUAL
</cfquery>
This works as i needed it to, but my problem is now updating that value in
another table
<cfquery name="Get_DT" datasource="My_DS">
UPDATE MyTable set LAST_UPDATE = '#Get_DT.LAST_UPDATE#'
....
</cfquery>
This gives me an error stating it is an invalid date. Any ideas on how to
accomplish this??
Thanks,
Scott
------_=_NextPart_001_01C0038B.D2275F00
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=700385911-11082000>I found this query
to return the date W/ a time value in Oracle in the forums. This seems to
be the only way to get it to retrieve a time value for me:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=700385911-11082000></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=700385911-11082000><cfquery
name="Get_DT" datasource="My_DS"></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=700385911-11082000>select
to_char(SYSDATE, 'DD-MM-YYYY HH24:MI:SS') LAST_UPDATE</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=700385911-11082000>from
DUAL</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=700385911-11082000></cfquery></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=700385911-11082000></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=700385911-11082000>This works as i
needed it to, but my problem is now updating that value in another
table</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2><SPAN class=700385911-11082000><cfquery
name="Get_DT" datasource="My_DS"></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=700385911-11082000>UPDATE MyTable set
LAST_UPDATE = '#Get_DT.LAST_UPDATE#'</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=700385911-11082000>....</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=700385911-11082000></cfquery></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=700385911-11082000></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=700385911-11082000>This gives me an
error stating it is an invalid date. Any ideas on how to accomplish
this??</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=700385911-11082000></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=700385911-11082000>Thanks,</SPAN></FONT></DIV></FONT></DIV>
<DIV><FONT face=Arial size=2>Scott </FONT></DIV></BODY></HTML>
------_=_NextPart_001_01C0038B.D2275F00--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
