<div>
try LSDateFormat()<br />
<br />
Mause
</div>


<div>
I already am. &nbsp;I'm displaying it as so:<br />
<br />
#LSDateFormat(jobs.APPLY_B<wbr />Y,'DDDD, MMMM DD YYYY')#<br />
<br />
It's the entering the data I need to get sorted, not the displaying I think....
</div>


I already am.  I'm displaying it as so:

#LSDateFormat(jobs.APPLY_BY,'DDDD, MMMM DD YYYY')#

It's the entering the data I need to get sorted, not the displaying I think....

<div>
let the date will be inserted in the default database format !<br />
<br />
change the display when u r displaying it on the browser - using dateformat()<br />
<br />
OR chnage the default date settings for ur DB !<br />
<br />
HTH<br />
<br />
K'Rgds<br />
Anand
</div>


let the date will be inserted in the default database format !

change the display when u r displaying it on the browser - using dateformat()

OR chnage the default date settings for ur DB !

HTH

K'Rgds
Anand

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I'm using a MySQL database and I'm trying to insert a date into it using a web form in the format DD/MM/YY (UK style) &nbsp;01/11/03 - 1st Novmeber 03.<br />
<br />
When I insert a date using a form I use the following code:<br />
<br />
&lt;cfqueryparam value=&quot;#FORM.APPLY_BY#&quot; cfsqltype=&quot;cf_sql_timestam<wbr />p&quot;&gt;<br />
<br />
But when I display the value on a web page, I find that the database has inserted my date as MM/DD/YY (US Style) &nbsp;01/11/03 - 11th January 03.<br />
<br />
How can I change the insert code, so that it can be inserted DD/MM/YY?<br />
<br />
Thanks in advance
</div>
</div>


Hi

I'm using a MySQL database and I'm trying to insert a date into it using a web form in the format DD/MM/YY (UK style)  01/11/03 - 1st Novmeber 03.

When I insert a date using a form I use the following code:

<cfqueryparam value="#FORM.APPLY_BY#" cfsqltype="cf_sql_timestamp">

But when I display the value on a web page, I find that the database has inserted my date as MM/DD/YY (US Style)  01/11/03 - 11th January 03.

How can I change the insert code, so that it can be inserted DD/MM/YY?

Thanks in advance

UK Dates

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.