Re: convert date(string) to date (date time)

•

What is DaniWeb IT Discussion Community?

You're currently browsing the JavaScript / DHTML / AJAX section within the Web Development category of DaniWeb, a massive community of 397,703 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,396 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our JavaScript / DHTML / AJAX advertiser: Lunarpages Web Hosting

convert date(string) to date (date time)

•

Join Date: Mar 2007

Posts: 83

Reputation: rgtaylor is an unknown quantity at this point

Rep Power: 0

Solved Threads: 2

rgtaylor

Offline

Junior Poster in Training

Re: convert date(string) to date (date time)

Apr 6th, 2007

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,

DaniWeb Home > Forums > Web Development > JavaScript / DHTML / AJAX > convert date(string) to...

Re: convert date(string) to date (date time)

convert date(string) to date (date time)

Re: convert date(string) to date (date time)