- see footer for list info -<
Left(convert(varchar(20),getdate(),108),5)
Sent from my iPhone so please excuse the brevity, poor spelling and
any bad grammar.
On 21 Jul 2008, at 14:29, "Snake" <[EMAIL PROTECTED]> wrote:
- 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 -<
_______________________________________________
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 -<
