RE: Date Timestamp??
you can createODBCDateTime in CF Code, or create a field in the database that is not null and of datatype timestamp. You could also use the SQL Reserve: timestamp ~Simon -Original Message- From: HappyToad.com [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 11:04 AM To: CF-Talk Subject: Date Timestamp?? How do I input the current date and time into a database? In other words I want to time stamp an entry. Rich -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ 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.
Re: Date Timestamp??
Have you tried using #Now()# in your insert statement? That should work in most cases. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: HappyToad.com <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Tuesday, September 26, 2000 11:15 AM Subject: Date Timestamp?? >How do I input the current date and time into a database? In other words I >want to time stamp an entry. > >Rich > >--- --- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >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/cf-talk@houseoffusion.com/ 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.
RE: Date Timestamp??
If you are wanting to put the current date and time try this: #CreateODBCDateTime(Now())# That will insert the current date and time as a timestamp Larry Juncker Senior Cold Fusion Programmer Heartland Internet -Original Message- From: HappyToad.com [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 10:04 AM To: CF-Talk Subject: Date Timestamp?? How do I input the current date and time into a database? In other words I want to time stamp an entry. Rich -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ 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.
RE: Date Timestamp??
Try using the GetDate() function. This is in Transact SQL (M$ SQL 6.5 and 7 I think), I'm not sure if it is an ANSI function. If not, use: #DateFormat(Now(), 'mmm dd, ')# #TimeFormat(Now(), 'HH:mm:ss')# in Cold Fusion. Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Just what the heck is a Turbo Squid?!?!?!?!?!? Ask me... -Original Message- From: HappyToad.com [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 10:04 To: CF-Talk Subject: Date Timestamp?? How do I input the current date and time into a database? In other words I want to time stamp an entry. Rich -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ 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.
RE: Date Timestamp??
#CreateODBCDateTime(Now())# -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- > -Original Message- > From: HappyToad.com [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 26, 2000 8:04 AM > To: CF-Talk > Subject: Date Timestamp?? > > > How do I input the current date and time into a database? In other words I > want to time stamp an entry. > > Rich > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Date Timestamp??
> How do I input the current date and time into a database? Rich The simplest way is to set up the table so that the current date/time is the default value for that column. Then you don't need to timestamp it yourself, the DBMS does it for you. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: Date Timestamp??
either let the database do it, or insert #CreateODBCDateTime(Now())# ~Simon -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 11:48 AM To: CF-Talk Subject: RE: Date Timestamp?? > How do I input the current date and time into a database? Rich The simplest way is to set up the table so that the current date/time is the default value for that column. Then you don't need to timestamp it yourself, the DBMS does it for you. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ 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.
Re: Date Timestamp??
Wouldn't it be better to let the database handle it instead of CF? Which database are you using Rich? Regards, Marc Garrett - Original Message - From: "Larry Juncker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, September 26, 2000 11:32 AM Subject: RE: Date Timestamp?? > If you are wanting to put the current date and time try this: > > #CreateODBCDateTime(Now())# > > That will insert the current date and time as a timestamp -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: Date Timestamp??
Access. I have it working ok with the #Now()# input. Is this a problem? Rich -Original Message- From: Marc Garrett [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 1:44 PM To: CF-Talk Subject: Re: Date Timestamp?? Wouldn't it be better to let the database handle it instead of CF? Which database are you using Rich? Regards, Marc Garrett - Original Message - From: "Larry Juncker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, September 26, 2000 11:32 AM Subject: RE: Date Timestamp?? > If you are wanting to put the current date and time try this: > > #CreateODBCDateTime(Now())# > > That will insert the current date and time as a timestamp -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ 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.
RE: Date Timestamp??
Or, if you are using ODBC as opposed to native drivers, you could use the
odbc escape sequences:
INSERT INTO a_table (aDate, aText) Values ({fn CURRENT_TIMESTAMP()},
'TEST')
{fn is a "curly-brace fn " not "parenthesis fn".
check them out at:
http://msdn.microsoft.com/library/psdk/dasdk/odch34df.htm
Appendix C and Appendix E
-Original Message-
From: Marc Garrett [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 26, 2000 10:44 AM
To: CF-Talk
Subject: Re: Date Timestamp??
Wouldn't it be better to let the database handle it instead of CF? Which
database are you using Rich?
Regards,
Marc Garrett
- Original Message -
From: "Larry Juncker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, September 26, 2000 11:32 AM
Subject: RE: Date Timestamp??
> If you are wanting to put the current date and time try this:
>
> #CreateODBCDateTime(Now())#
>
> That will insert the current date and time as a timestamp
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
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.
Re: Date Timestamp??
In Access, you can set the datatype to date/time and the default value to Date(). Typically it's better to let a database handle that type of function instead of ColdFusion, but with low site traffic I don't know that it makes any difference. Regards, Marc Garrett - Original Message - From: "HappyToad.com" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, September 26, 2000 4:07 PM Subject: RE: Date Timestamp?? > Access. I have it working ok with the #Now()# input. Is this a problem? > > Rich > > -Original Message- > From: Marc Garrett [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 26, 2000 1:44 PM > To: CF-Talk > Subject: Re: Date Timestamp?? > > > Wouldn't it be better to let the database handle it instead of CF? Which > database are you using Rich? > > Regards, > > Marc Garrett > > - Original Message - > From: "Larry Juncker" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, September 26, 2000 11:32 AM > Subject: RE: Date Timestamp?? > > > > If you are wanting to put the current date and time try this: > > > > #CreateODBCDateTime(Now())# > > > > That will insert the current date and time as a timestamp > > > -- -- > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ > 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/cf-talk@houseoffusion.com/ 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.
RE: Date Timestamp??
When designing the database set a default value of "Now()" to your date field. When ever a record is inserted or updated the latest ODBC date/time will be applied automatically. Peter Tilbrook Internet Applications Developer Aspect Computing Pty. Ltd. 19-25 Moore Street Turner, ACT, 2612 AUSTRALIA http://www.aspect.com.au Phone: (02) 6247 7677 Fax: (02) 6249 1620 Mobile: 0428 765 020 ICQ: 666275 ACT ColdFusion Users Group - http://203.37.24.198 -Original Message- From: HappyToad.com [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 27 September 2000 1:04 To: CF-Talk Subject: Date Timestamp?? How do I input the current date and time into a database? In other words I want to time stamp an entry. Rich -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ 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.
RE: Date Timestamp??
In Access I just create a default value for a field in Access itself using Date()+Time() Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 -Original Message- From: HappyToad.com [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 27 September 2000 12:34:AM To: CF-Talk Subject: Date Timestamp?? How do I input the current date and time into a database? In other words I want to time stamp an entry. Rich -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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. This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: Date Timestamp??
> If you are wanting to put the current date and time try this: > > #CreateODBCDateTime(Now())# > > That will insert the current date and time as a timestamp Actually, the CreateODBCDateTime function isn't required here, as the Now function creates an ODBC date/time stamp. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: Date Timestamp?? OK
The #Now()# worked ok. thanks for the help, Rich -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 11:44 AM To: CF-Talk Subject: RE: Date Timestamp?? Try using the GetDate() function. This is in Transact SQL (M$ SQL 6.5 and 7 I think), I'm not sure if it is an ANSI function. If not, use: #DateFormat(Now(), 'mmm dd, ')# #TimeFormat(Now(), 'HH:mm:ss')# in Cold Fusion. Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Just what the heck is a Turbo Squid?!?!?!?!?!? Ask me... -Original Message- From: HappyToad.com [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 10:04 To: CF-Talk Subject: Date Timestamp?? How do I input the current date and time into a database? In other words I want to time stamp an entry. Rich -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ 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.
