1,105,592 Community Members

convert date(string) to date (date time)

Member Avatar
Mohandsa
Newbie Poster
11 posts since Oct 2006
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

please,help me i want to convert date(string) to date (date time), this date i make setting for day with one (constant)
to use it in database i write in html
<html>
<head>
<SCRIPT type="text/javascript">
function startDate()
{
var d=new Date()
var y=d.getYear()
var m=d.getMonth()+1
var day=1
var date=m+"/"+day+"/"+y
document.write("date is: "+date)
// OUTPUT WILL BE 4/1/2007 THIS IS STRING I NEEED IT DATETIME //
var dat=Date.parse(date);
document.write("date is: "+dat)
// OUTPUT WILL BE 1175378400000 //
// PLEASE HELP ME TO GET TRUE RESULT //
}
</SCRIPT>
</head>
<body onload="startDate()" >
</body>
</html>

Member Avatar
rgtaylor
Junior Poster in Training
83 posts since Mar 2007
Reputation Points: -2 [?]
Q&As Helped to Solve: 2 [?]
Skill Endorsements: 0 [?]
 
0
 

OK, it seems you posted twice this time with more detail... this should be posted to the Javascript lists rather than JSP lists... BUT, a date object, or datetime is just a long numberic value... counting (usually) seconds or militseconds sine the "Epoc" time... usually Jan, 1 1970 00:00:00...

You have actually got what you need for a database, which you do an insert SQL with passing the long value to a datetime column, depending upon the database should result int he correct DB value being saved... you are confusing, I think, human readability with machine readability...

The first one you show, your string is human readable, while the number is how the machine will see it when it is properly converted to a date object...

In Java, when we have a date object which represents a given date, the toString will show it as 2007-04-01 while we insert it into the DB as a timestamp with setTimestamp(1, date.getTime())...
The getTime() method of the Date object returns a "long" with is just a number with lots of places... this is what the DB requires to understand the time....

Peace,

Member Avatar
vikki.v
Newbie Poster
1 post since Jun 2007
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

hi,
how can i convert
var dat=Date.parse(date);
("dat" has 1175378400000)

dat again to date (i.e.,4/1/2007)
thanx in advance

please,help me i want to convert date(string) to date (date time), this date i make setting for day with one (constant)
to use it in database i write in html
<html>
<head>
<SCRIPT type="text/javascript">
function startDate()
{
var d=new Date()
var y=d.getYear()
var m=d.getMonth()+1
var day=1
var date=m+"/"+day+"/"+y
document.write("date is: "+date)
// OUTPUT WILL BE 4/1/2007 THIS IS STRING I NEEED IT DATETIME //
var dat=Date.parse(date);
document.write("date is: "+dat)
// OUTPUT WILL BE 1175378400000 //
// PLEASE HELP ME TO GET TRUE RESULT //
}
</SCRIPT>
</head>
<body onload="startDate()" >
</body>
</html>

Member Avatar
ehassen
Newbie Poster
1 post since May 2010
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
1
 

var dat=Date.parse(date);
var theDate = new Date(dat);
//where dat is a long numeric sequence representing the epochmilliseconds.

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article