Retrieving date from mysql to javascript gives invalid date

Question

This is the code and the mysql table

Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/2a", "root", "root");
Statement st=con.createStatement();
ResultSet rsta=st.executeQuery("Select * from data");
while(rsta.next()) {
  x14=rsta.getTime("strtime");
}
%>
<div id="TextBoxesGroup">
<input type="hidden" id="time" name="time" value="<%=x14%>"/>
</div>
<script>

$(document).ready(function(){     
    var dateString=$('#time').val();
    var d1 = new Date(dateString);


    var newTextBoxDiv = $(document.createElement('div'))
         .attr("id", 'TextBoxDiv' + counter);
    newTextBoxDiv.after().html('<div><label style="float:left;">'+d1+'</label>);
    newTextBoxDiv.appendTo("#TextBoxesGroup");  
</script>


+---------+-------------+------+-----+---------+----------------+
| Field   | Type        | Null | Key | Default | Extra          |
+---------+-------------+------+-----+---------+----------------+
| id      | int(11)     | NO   | PRI | NULL    | auto_increment |
| date    | date        | YES  |     | NULL    |                |
| strtime | time        | YES  |     | NULL    |                |
| endtime | time        | YES  |     | NULL    |                |
| freq    | varchar(30) | YES  |     | NULL    |                |
| inter   | int(11)     | YES  |     | NULL    |                |
+---------+-------------+------+-----+---------+----------------+

The variable d1(it is saved as time in db) gives me invalid date.why is this happening?Am I missing something?

Let me know incase more info is required but do help.

var d1 = new Date("October 13, 1975 11:13:00") this is the default format — Sureshkumar Panneerselvan, Dec 24 '13 at 07:19

Sureshkumar Panneerselvan · Accepted Answer · 2013-12-24T07:41:15.220

1

There are four ways of initiating a date:

new Date() // current date and time
new Date(milliseconds) //milliseconds since 1970/01/01
new Date(dateString)
new Date(year, month, day, hours, minutes, seconds, milliseconds)

Most parameters above are optional. Not specifying, causes 0 to be passed in.

Once a Date object is created, a number of methods allow you to operate on it. Most methods allow you to get and set the year, month, day, hour, minute, second, and milliseconds of the object, using either local time or UTC (universal, or GMT) time.

All dates are calculated in milliseconds from 01 January, 1970 00:00:00 Universal Time (UTC) with a day containing 86,400,000 milliseconds.

Some examples of initiating a date:

var today = new Date()
var d1 = new Date("October 13, 1975 11:13:00")
var d2 = new Date(1979,5,24)
var d3 = new Date(1979,5,24,11,33,0)

Its date object so u should need dateString not timeString.

edited Dec 24 '13 at 07:41

answered Dec 24 '13 at 07:20

Sureshkumar Panneerselvan

749
6
22

use comma separated as above or use milliseconds to construct date in javascript – Sureshkumar Panneerselvan Dec 24 '13 at 07:23
But I am retrieving the db value(strtime),how should I pass this in javascript? if you could show me – Santino 'Sonny' Corleone Dec 24 '13 at 07:25
Its date object not time. – Sureshkumar Panneerselvan Dec 24 '13 at 07:26
so in my database probably i will have to change the column type to datetime? – Santino 'Sonny' Corleone Dec 24 '13 at 07:28
If possible u can. Use time-stamp to process. – Sureshkumar Panneerselvan Dec 24 '13 at 07:29
let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/43808/discussion-between-sureshkumar-panneerselvan-and-vidic) – Sureshkumar Panneerselvan Dec 24 '13 at 07:35
I did it.I passed the date along with the time in the d1 variable..thnx for the help – Santino 'Sonny' Corleone Dec 24 '13 at 07:38
whatever close the question by accepting. So it will useful to others. – Sureshkumar Panneerselvan Dec 24 '13 at 07:44

score 0 · Answer 2 · answered Dec 24 '13 at 07:54

Here is a helper function to get proper date object from your custom time format

var helper = function(time) {
    var regex = /^\s*((0?[0-9])|(1?[0-9])|(2?[0-3]))\s*\.\s*[0-5]?[0-9]\s*:\s*[0-5]?[0-9]\s*$/g;
    time = time.match(regex);

    if(time && time.length === 1) {
        time = time[0];
        var date = new Date();
        var endIndex = time.indexOf('.');
        var hr = Number(time.substr(0, endIndex).trim());
        time = time.substr(endIndex + 1).trim();
        endIndex = time.indexOf(':');             
        var min = Number(time.substr(0, endIndex).trim());
        time = time.substr(endIndex + 1).trim();                
        var sec = Number(time);
        date.setHours(hr);
        date.setMinutes(min);
        date.setSeconds(0);
        return date;
    }

    return null;
};

This will accept the time in HH.MM:SS in 24 hour format and return the date object initialized to current date.

score 0 · Answer 3 · answered Aug 08 '19 at 09:10

0

I think type Time in Mysql has format HH:mm:ss So you can not parse it as date use javascript. You need to combine date and strtime when get data from mysql

 x14= rsta.getDate("date") + " " +  rsta.getTime("strtime");

answered Aug 08 '19 at 09:10

Nguyễn Hùng Hậu

97
2

Retrieving date from mysql to javascript gives invalid date

3 Answers3