Date_format - ASP / Active Server Pages

Date Format
I have a program running at the moment but the date format keep on changing every time I update my database. Date format is on UK format dd/mm/yy but when I update or save it, turns to US format mm/dd/yy. Please help!

Jun 20 '07 #1

Subscribe Post Reply

1406

jhardman

3,406

Expert 2GB

Date Format
I have a program running at the moment but the date format keep on changing every time I update my database. Date format is on UK format dd/mm/yy but when I update or save it, turns to US format mm/dd/yy. Please help!

this is actually a system setting. the best way to work around it that I have seen is to use non-interpretable date formats (like 1-Jan-2007), whatever you can find that your system will still recognize as a date so you can still manipulate it. As long as you can still manipulate it, display it on the web in whatever format you prefer, but send it to the db in some non-ambiguous format.

Jared

Jun 20 '07 #2

Similar topics

SELECTing using DATE_FORMAT

by: Rick | last post by:

I have been trying to run this MySQL query using PHP: SELECT id, trans_type, remote_addr, DATE_FORMAT(time, '%M %e, %Y %r') as time FROM...

PHP

syntax error date_format

by: Johan den Boer | last post by:

Hi, What is wrong with this code ? SELECT DATE_FORMAT( myfield, GET_FORMAT( TIMESTAMP, 'EUR' ) ) FROM T_TABLE; regards Johan

MySQL Database

CAST / Date_FORMAT function

by: Jimmy | last post by:

Hi, I'm new to MySQL and I have qustion regarding to CAST and Date_Format functions. I'm trying to convert a column 'Time' varchar(50) to...

MySQL Database

changing the date_format

by: sang | last post by:

Hai I want to change the date format at the time of inserting the record. i done it but one error in the insertion. The query is ...

MySQL Database

problem in mysql date_format

by: sang | last post by:

Hi In my table the date format is changed to 06-feb-2007.The query i execute is select date_format(col.name,"%e-%b-%Y") from tablename; ...

MySQL Database

date_format problem

by: adamalton | last post by:

I am trying to take a date in the format "YYYY-MM-DD" and get from it the month as a word (e.g. July) and the day as a 2 digit number (e.g. 24). I...

PHP

Query inconsistency (MySQL vs PHP) -> DATE_FORMAT

by: laverdir | last post by:

<? $query = "SELECT " . $this->tabela3 . ".id, " . $this->tabela3 . ".naziv, " . $this->tabela3 . ".spisatelj, " . $this->tabela3 . ".najava, " ....

PHP

select with DATE_FORMAT( )

by: docscsi | last post by:

Dear all I'm quite new to mysql. My aim is to select a date format field by returning only the month and day number of it (e.g. date = 11 12). I...

PHP

date_format fatal error

by: ann86 | last post by:

Hello, I am a newbie to PHP and I am working on a site that was created by someone else. The server was updated yesterday so now I am getting the...

PHP

Benefits of Blockchain App Development for Enterprise Businesses

by: Kemmylinns12 | last post by:

Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...

General

Basic concepts of WebLogic Admin training?

by: Naresh1 | last post by:

What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...

Oracle Database

https redirect with reverse proxy

by: jalbright99669 | last post by:

Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...

IIS / Internet Information Server

Hyperconverged All-in-One Streaming Engine, ushering in new age for distributed database

by: antdb | last post by:

Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...

General

How to use http requests (Get function) to get variable value?

by: Matthew3360 | last post by:

Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...

Python

by: WisdomUfot | last post by:

It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...

General

FPGA Question

by: Oralloy | last post by:

Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...

General

One of the easiest ways to set the background color of Excel documents in Java

by: Carina712 | last post by:

Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....

General

Join our open community on Discord to learn programming, SEO, and marketing

by: BLUEPANDA | last post by:

At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...

General