> Your ms sql server column "RequestsDate" is of type date/time - right? In my > database it's of type timestamp - totally different data type.
just to really rub it in: timestamp in sql server (as opposed to cf dealing with sql server's datetimes) is a binary(8) or varbinary(8) equivalent. Steve, after looking at this last night, your request is kinda tougher than it 1st looks. if you've returned a TS value as part of some previous resultset, i guess the best bet is that you'll have to go back and CAST it as an integer on the way out--i just tried various varchar combos *after* pulling it from the db & none returned the timestamp correctly. the global var @@dbTS returns the db's current timestamp value. its value in my db is 0x0000000000011307 (int equivalent to 70407). this is the t-sql code i used to test: declare @x varchar(50) set @x='0000000000011307' select @@dbts, cast(@x as binary(8)), cast(@@dbts as int), cast(70407 as timestamp) which returns: real dbTS:=0x0000000000011307, cast from varchar:=0x3030303030303030, (wrong) cast as int:=70407, cast int back to TS:=0x0000000000011307 (right) this db system is relatively quite lately, so i have no idea if you'll overflow an int datatype if you really pound tables with TS columns... is this what you're after? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
