What did you try? Why don't you read the documentation? Do you think your computer or we here should be able to read your mind?
here is my testrun, everything works as it should - don't just make something up in your head and falter surrender if that failes, read the documentation carefully, experiment with the stuff you read and think:
mysql> create table tstest( ts timestamp not null default now());
Query OK, 0 rows affected (0.03 sec)
mysql> insert into tstest values(from_unixtime(114454234));
Query OK, 1 row affected (0.00 sec)
mysql> select * from tstest;
+---------------------+
| ts |
+---------------------+
| 1973-08-17 17:50:34 |
+---------------------+
1 row in set (0.00 sec)
Edit: altered a word to get nearer to the intended meaning...(marked via strike out)
regards,
tomte
An intellectual is someone whose mind watches itself. -- Albert Camus
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|