displaying the date in mysql format for insertion into db

libsfan01 · Jun 13, 2006

HI all!

ive need to format the date (variable "tomorrow") in this form to mysql
format yyyy-mm-dd can anyone please show me how to amend my script?

regards

Marc

<script language="javascript">

function showDate(thisObj){
/* create a Date object using the system clock */
today=new Date();
td = today.getDate();
tm = today.getMonth();
ty = today.getFullYear();
tomorrow=new Date(ty,tm,td+1)

/* convert contents to string and place in control */
document.getElementById(thisObj).value=tomorrow;
}

</script>
<body onLoad="showDate('date');">

<input id="date" type="text" readonly="readonly" />

</body>

RobG · Jun 13, 2006

libsfan01 said:
HI all!

ive need to format the date (variable "tomorrow") in this form to mysql
format yyyy-mm-dd can anyone please show me how to amend my script?

regards

Marc

<script language="javascript">

The language attribute is deprecated, type is required:

function showDate(thisObj){
/* create a Date object using the system clock */
today=new Date();

Always use var to keep variables local unless you really do need globals:

var today = new Date();

And tomorrow is:

var x = new Date();
x.setDate(x.getDate() + 1);

Now x is tomorrow's date[1]. You may need to be careful around
midnight, getting today's date at 23:59:59 may result in tomorrow being
today very soon.

td = today.getDate();
tm = today.getMonth();
ty = today.getFullYear();
tomorrow=new Date(ty,tm,td+1)

/* convert contents to string and place in control */
document.getElementById(thisObj).value=tomorrow;

function addZ(n){
return (n<10)? '0'+n : ''+n;
}

...value = x.getFullYear()
+ '-' + addZ(x.getMonth()+1)
+ '-' + addZ(x.getDate());

1. Creating a date of say - new Date('2006/06/31') - will result in 1st
of July, or - new Date('2006/06/32') - 2nd of July.

Date format	1	Apr 18, 2008
Date format DD/MM/YYYY	1	Apr 18, 2008
Date dropdown not functioning	6	Oct 26, 2006
no error in mozilla but not displaying calendar	0	Jan 17, 2006
comparevalidator control interprets date in the wrong format	0	Apr 11, 2008
What determines the date/time format for SELECT statements in Rails?	1	Apr 14, 2005
modifying html input date for mysql, reg ex or string interpolation?	2	Apr 11, 2006
Does CompareValidator work for the date in dd-mmm-yyyy format?	3	Jun 10, 2005

displaying the date in mysql format for insertion into db

libsfan01

RobG

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads