>- see footer for list info -< Alas no -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Lynch Sent: 21 July 2008 14:19 To: Coldfusion Development Subject: RE: [CF-Dev] RE: extracting time part from dates
>- see footer for list info -< Does swapping 'mi' to 'nn' hold onto the 0? Adrian -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Snake Sent: 21 July 2008 11:35 To: 'Coldfusion Development' Subject: [CF-Dev] RE: extracting time part from dates >- see footer for list info -< OK all I want to do is extract the time from a datetime field in the database (SQL server), but it is stripping 00 and converting to 0. E.G. Original column: 2006-06-28 08:00:00.0 Converts to : 8:0 I am currently using select slotid,dayofshow,forall,alldesc,starttime,endtime, datename(hh,starttime) + ':' + datename(mi,starttime) as starttime2, datename(hh,endtime) + ':' + datename(mi,endtime) as endtime2 from slots I have also tried using DatePart() with the same result. Surely these functions should not do this ? And no I cannot use CF to format it, it has to be in the right format in the query. - Russ Michaels Certified ColdFusion Professional My Blog: www.russ.michaels.me.uk _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
