AS/400 uses Julian date. That could be why there is a way in how you have to
add those in there. Ask the RPG programmers what they put in for date and
time. I forgot all about that.
Bob Everland
-----Original Message-----
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 31, 2000 10:09 PM
To: [EMAIL PROTECTED]
Subject: Re: Custom Tag for Date and Time
thanks, but still did not work. I am using db2-as/400 as backend. how do
i define a timestamp field since that is essentially what i would
probably want.
"Chapman, Katrina" wrote:
>
> Either use
>
> <cfquery name="Insert" datasource="lsars">
> insert into taavon.history
> (lid,summary,completedby,assignedby,comptime)
> values ('#url.lid#',
> '#form.summary#','#url.assigned#','',#CreateODBCDateTime(Now())#)
> </cfquery>
>
> Or
>
> <cfquery name="Insert" datasource="lsars">
> insert into taavon.history
> (lid,summary,completedby,assignedby,comptime)
> values ('#url.lid#', '#form.summary#','#url.assigned#','',Now())
> </cfquery>
>
> If you're using SQL server you can use
>
> <cfquery name="Insert" datasource="lsars">
> insert into taavon.history
> (lid,summary,completedby,assignedby,comptime)
> values ('#url.lid#',
'#form.summary#','#url.assigned#','',GetDate())
> </cfquery>
>
> Or
>
> <cfquery name="Insert" datasource="lsars">
> insert into taavon.history
> (lid,summary,completedby,assignedby,comptime)
> values ('#url.lid#', '#form.summary#','#url.assigned#','',sysdate)
> </cfquery>
>
> HTH,
> --K
>
> > -----Original Message-----
> > From: James Taavon [SMTP:[EMAIL PROTECTED]]
> > Sent: Monday, July 31, 2000 11:07 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Custom Tag for Date and Time
> >
> > Philip,
> >
> > I tried this...
> >
> > <cfquery name="Insert" datasource="lsars">
> > insert into taavon.history
> > (lid,summary,completedby,assignedby,comptime)
> > values ('#url.lid#', '#form.summary#','#url.assigned#','',#Now()#)
> > </cfquery>
> >
> >
> >
> > and got an error...
> >
> > ODBC Error Code = 22008 (Datetime field overflow)
> >
> > [IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]SQL0180 - Syntax
> > of date,
> > time, or timestamp value not valid.
> >
> > The error occurred while processing an element with a general
> > identifier of (CFQUERY),
> > occupying document position (9:1) to (9:42).
> >
> > Any ideas?
> >
> >
> > Philip Arnold - ASP wrote:
> > >
> > > > Any one have a custom tag that retrieves both the DateFormat (Now())
> > and
> > > > TimeFormat (Now()) as one function that can be inserted into a
> > database?
> > >
> > > I assume you've got your field as a DateTime format - if not, then
> > change it
> > > to be DateTime
> > >
> > > Also, try to use the database native functions - Now() for Access and
> > > GetDate() for SQL Server - it'll be faster and cleaner than getting CF
> > to do
> > > the work
> > >
> > > If you really want to use CF to do it, then use
> > > #CreateODBCDateTime(Now())# - assuming you're talking to the database
> > ODBC
> > > and not OLE DB
> > >
> > > Try not to use DateFormat and TimeFormat into a format that "looks"
> > right
> > > for you - the database server may look at is as just some text and
> > produce
> > > an error - if you're fixed on the idea of using a set DateFormat, then
> > use
> > > one that isn't ambigious, like "d mmm yyyy", that way, it can't be
> > > confused - DEFINITELY avoid formats like "mm/dd/yyyy" as some
databases
> > may
> > > interpret it as "dd/mm/yy" (depending on nationalisation)
> > >
> > > HTH
> > >
> > > Philip Arnold
> > > ASP Multimedia Limited
> > > T: +44 (0)20 8680 1133
> > >
> > > "Websites for the real world"
> > >
> > > **********************************************************************
> > > This email and any files transmitted with it are confidential and
> > > intended solely for the use of the individual or entity to whom they
> > > are addressed. If you have received this email in error please notify
> > > the system manager.
> > > **********************************************************************
> > >
> > >
>
> --------------------------------------------------------------------------
> > ----
> > > 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.
>
> --------------------------------------------------------------------------
> > ----
> > 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.
> --------------------------------------------------------------------------
----
> 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.
----------------------------------------------------------------------------
--
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.
------------------------------------------------------------------------------
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.
