>- 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
Commerical ColdFusion & BlueDragon Hosting: www.cfmxhosting.co.uk
FREE CFML Developer hosting : www.cfdeveloper.co.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 -<
