473,396 Members | 2,036 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

converting Date() to unix timestamp format?

hi

im trying to convert Date() into a unix timestamp so i can stick the
result into a mysql db, please help!

Mar 6 '07 #1
6 34053
Lee
ma**@gaspdesign.co.uk said:
>
hi

im trying to convert Date() into a unix timestamp so i can stick the
result into a mysql db, please help!
I've been using Unix since before you were born (I can tell by
the fact that you haven't learned to use the SHIFT key), and
have no idea what you mean by a "unix timestamp" and don't have
any inclination to look at mysql documentation to see what they
think it is.

Give an example of what you want.
--

Mar 6 '07 #2
Lee wrote:
m...@gaspdesign.co.uk said:
>im trying to convert Date() into a unix timestamp so i can
stick the result into a mysql db, please help!

I've been using Unix since before you were born (I can tell by
the fact that you haven't learned to use the SHIFT key), and
have no idea what you mean by a "unix timestamp"
Then you should definitely start learning about it!

http://en.wikipedia.org/wiki/Unix_Timestamp
http://www.unixtimestamp.com
and don't have any inclination to look at mysql documentation
to see what they think it is.
The Unix timestamp is well-known and defined; it is the number of
seconds since Epoch. But the MySQL timestamp is different, that uses
the YYYYMMDDHHmmSS-format. Since the objective is to store a timestamp
in MySQL, one should opt to play by the MySQL rules here. Suppose this
table:

CREATE TABLE `tt` (`a` timestamp(14) NOT NULL);

If the OP's intention is to insert the current time in db -which I
suspect- then just do:

INSERT INTO `tt` VALUES ( NOW() );

And then one could read it out as Unix timestamp:

SELECT UNIX_TIMESTAMP(a) FROM tt;

No need for any javascript or shell commands.

If the intention is to store a timestamp that is not the current one,
then let javascript's Date() calculate the specific time of your
interest in (MySQL's) YYYYMMDDHHmmSS-format, like eg. 20040318140523
for March 18 2004, 14:05:23. Then do:

INSERT INTO `tt` VALUES ( `20040318140523` );

Alternatively, in stead of using Date() in javascript, one could use
MySQL's date functions, which might be experienced as more terse and
powerful:

http://dev.mysql.com/doc/en/Date_and...functions.html

--
Bart

Mar 6 '07 #3
Lee
Bart Van der Donck said:
>
Lee wrote:
>m...@gaspdesign.co.uk said:
>>im trying to convert Date() into a unix timestamp so i can
stick the result into a mysql db, please help!

I've been using Unix since before you were born (I can tell by
the fact that you haven't learned to use the SHIFT key), and
have no idea what you mean by a "unix timestamp"

Then you should definitely start learning about it!

http://en.wikipedia.org/wiki/Unix_Timestamp
http://www.unixtimestamp.com
I've never heard Epoch time called "Unix timestamp". Maybe the
term is popular with non-Unix users?

It's also obviously, from your further description, not what
the OP meant.
--

Mar 6 '07 #4
Lee wrote:
I've never heard Epoch time called "Unix timestamp". Maybe the
term is popular with non-Unix users?
With Unix users in the first place, I'ld say...
It's also obviously, from your further description, not what
the OP meant.
The original poster wants to insert a timestamp in MySQL. The
recommended way to do that, is to use MySQL's TIMESTAMP data type,
which is intended especially for that purpose. MySQL knows the
UNIX_TIMESTAMP() function for quick&easy over-and-back conversions
between Unix' and MySQL's timestamps.

--
Bart

Mar 6 '07 #5
Lee
Bart Van der Donck said:
>
Lee wrote:
>I've never heard Epoch time called "Unix timestamp". Maybe the
term is popular with non-Unix users?

With Unix users in the first place, I'ld say...
Unix users don't call "ls" "the Unix ls command". They call it "ls".
Similarly, Unix users (the many that I know, at least) aren't likely
to call epoch time "the Unix timestamp".

If there's a mysql function called UNIX_TIMESTAMP(), then there's
a pretty good clue as to where the term originated.
--

Mar 6 '07 #6
In comp.lang.javascript message <11**********************@p10g2000cwp.go
oglegroups.com>, Tue, 6 Mar 2007 08:24:03, "ma**@gaspdesign.co.uk"
<ma**@gaspdesign.co.ukposted:
>im trying to convert Date() into a unix timestamp so i can stick the
result into a mysql db, please help!
In Javascript, Date() gives a string, and of undefined format (ISO 16262
15.9.2 &c). It's not a good starting-point for most requirements.

But new Date() gives a Date Object, and so + new Date() gives
the number of milliseconds (ignoring Leap Seconds, but not Summer Time)
since the Javascript Epoch. Converting that to the number of seconds
since the UNIX Epoch can be left as an exercise.

If you want a MySQL format from a Javascript group, you should give its
definition. Does it require to be in UTC or in local, with/without
offset in what form? In any case, reading the newsgroup FAQ should put
you in the right direction.

If you require a string YYYYMMDDhhmmss, it's easiest to use, in a string
context, Y*1e10 + M*1e8 + D*1e6 + h*1e4 + m*1e2 + s*1e0 .
BTW, in the FAQ, it may become desirable to convert from ISBN-10 to the
current ISBN-13 : see <URL:http://www.merlyn.demon.co.uk/js-misc0.htm>.

It's a good idea to read the newsgroup and its FAQ. See below.

--
(c) John Stockton, Surrey, UK. ?@merlyn.demon.co.uk Turnpike v6.05 IE 6
news:comp.lang.javascript FAQ <URL:http://www.jibbering.com/faq/index.html>.
<URL:http://www.merlyn.demon.co.uk/js-index.htmjscr maths, dates, sources.
<URL:http://www.merlyn.demon.co.uk/TP/BP/Delphi/jscr/&c, FAQ items, links.
Mar 6 '07 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Kit | last post by:
Howdy! I have some dates in a MySQL database that are in a 'Y-m-d' format. Is there a way to have PHP read these dates and convert them to a 'd-M-Y' format?
2
by: Ben | last post by:
I would like to use php to query a database and retrieve a unix timestamp. The problem is that mysql is storing the data in the date format and not a timestamp. I am sure that I can amend my...
13
by: perplexed | last post by:
How do you convert a user inputted date to a unix timestamp before insterting it into your database? I have a form, with a textfield for a date that the user inputs in the format mm-dd-yyyy and...
11
by: Rick | last post by:
I am going crazy on how to format a simple date. I have this in my MySQL table. "2005-03-10 08:44:21" and I want it to format out like "3/10/2005" or "03/10/05" but I seem to be going at it the...
6
by: bryan.seaton | last post by:
I have a delete statement that is not doing what I want it to do: Delete from LOG_TABLE where (DATE(LOG_TS)) < (DATE(CURRENT_DATE)- 21 DAYS); It is supposed to delete all records that are 21...
4
by: hph | last post by:
Okay, another trivial matter that I can't solve. I have a variable - $lastdate - that is the latest date any record in a MySQL database was updated. Its MySQL format is TIMESTAMP. If I say I...
3
by: Tgone | last post by:
Hello, I need to convert a MySQL date "2007-03-08", into "March 8th, 2007". Normally I would use MySQL to accomplish this task but I have to use PHP. Here's my code: echo date("F jS, Y",...
3
by: dave | last post by:
I need to compute an expiration date based on the number of hours, days, or months purchased. The expiration date needs to be expressed in minutes something like '1260481600'. How can I get the...
4
by: mtuller | last post by:
I have a database that stores time in 2 different formats. I have a unix timestamp, and the other is a representation of time in the format 03:00:00 which would represent 3 hrs. I want to convert...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.