On Wednesday 14 Jan 2004 16:33 pm, Harry Klein wrote:
> > Depends what string format'ed date you supply to them.
>
> Sorry, but i don't understand this answer: thisdate is always of type
> date?
Well, ultimetly, a user has typed the string representing the date in.
Some formats people enter dates in if allowed will not work, so we force them
to use one.
> It doesn't matter how the user supplies the date information
> 02.03.2004 (european format)
> 03/02/2004 (us format)
> 3,2,2004 - separate entries
> ...
> I am always converting the user entries into a date type field.
> (with CreateDateTime(), ParseDateTime(), ...)
Oh, right, no we don't do that.
> So you are still using
> to_date('#Dateformat(thisdate,'mm/dd/yyyy')#
> #TimeFormat(thisdate,'HH:mm:ss')#', 'MM/DD/YYYY HH24:MI:SS')
Yeah, though I'm trying to standerdise on
to_date("#thisDate# #thisTime#",'DD-MON-YYYY HH24:MI')
> instead of
> <cfqueryparam cfsqltype="CF_SQL_TIMESTAMP"
> value="#CreateODBCDateTime(thisdate)#">
I haven't tried that one - intresting to see how it gets on.
We've had problems (here in the UK) where dateformat would allow through
things that were valid US style (mm/dd/yy) dates, but not valid UK style
(dd/mm/yy) despite settting locale etc. It would basicaly mix up day and
month, if the date made sense in both formats, and was entered as a UK style.
That was CF4.5 though.
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email
to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev'
in the message of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported
by Mindtool, Corporation (www.mindtool.com).
An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
