OpenForum RSS: Mysql � str_to_date

Mysql � str_to_date (Nybos)

Mon, 28 Feb 2011 13:00:40 GMT

�� . ��. �� , � �� ... �� (

Mysql � str_to_date (Nybos)

Mon, 28 Feb 2011 12:58:50 GMT

>[�� ]
> | 5.1.55 |
> +-----------+
> 1 row in set (0.00 sec)
> mysql> select date_format('2010-08-24 15:56:56','%Y-%m-%d %H-%i-%s') as date_format;
> +---------------------+
> | date_format |
> +---------------------+
> | 2010-08-24 15-56-56 |
> +---------------------+
> 1 row in set (0.00 sec)

��! ��, �� - �� ? �� %i � �.�. �� :-(

Mysql � str_to_date (juriskr)

Mon, 28 Feb 2011 12:10:51 GMT

> �� ! �� str_to_date.
> �� 2010-08-24 15:56:56 � %Y-%m-%d %H-%i-%s.
> � �� STR_TO_DATE ('2010-08-24 15:56:56','%Y-%m-%d %H:%i:%s') ��.

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.1.55 |
+-----------+
1 row in set (0.00 sec)

mysql> select date_format('2010-08-24 15:56:56','%Y-%m-%d %H-%i-%s') as date_format;
+---------------------+
| date_format |
+---------------------+
| 2010-08-24 15-56-56 |
+---------------------+
1 row in set (0.00 sec)