Use getDate() Chuck McElwee etech solutions inc www.etechsolutions.com
-----Original Message----- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 9:22 PM To: CF-Talk Subject: RE: Timestamp as lastupdate Timestamp doesn't store a date. C.f. http://www.sqlteam.com/item.asp?ItemID=1410Regards, -----Original Message----- From: Office [mailto:[EMAIL PROTECTED]] Sent: Friday, 12 April 2002 11:52 a.m. To: CF-Talk Subject: Timestamp as lastupdate I used the "timestamp" field type in a MS SQL7.0 table as "lastupdate" I want to output this on a .cfm webpage as "last update" This is what I got. ------------------------- 0000000000038FB3 ------------------------- What am I doing wrong here. I sort of hoped it would be something like 2002/04/11 that could be formated. Thanks for any advice Mike Peters ---------------------------------------------------- NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz ---------------------------------------------------- ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists