Re: FormatDateTime Revisited
- From: Pedro Graca <hexkid@xxxxxxxxxxx>
- Date: 17 Jan 2006 20:17:02 GMT
John K wrote:
> I need to format the date going "into" the database.
mysql> create table foo (id int primary key auto_increment, t1 datetime, t2 timestamp);
Query OK, 0 rows affected (0.03 sec)
mysql> insert foo (t1, t2) values (20060117201703, 20060117201703);
Query OK, 1 row affected (0.05 sec)
mysql> select * from foo;
+----+---------------------+---------------------+
| id | t1 | t2 |
+----+---------------------+---------------------+
| 1 | 2006-01-17 20:17:03 | 2006-01-17 20:17:03 |
+----+---------------------+---------------------+
1 row in set (0.00 sec)
--
If you're posting through Google read <http://cfaj.freeshell.org/google>
.
- References:
- FormatDateTime Revisited
- From: John K
- FormatDateTime Revisited
- Prev by Date: Re: PHP Access to MySql
- Next by Date: Re: plot graphic lines and text dynamically
- Previous by thread: Re: FormatDateTime Revisited
- Next by thread: Object Oriented PHP Book Suggestions
- Index(es):
Relevant Pages
|
