Results 1 to 8 of 8
Thread: MySQL: Text Date
Hybrid View
-
27th January 2009 23:35 #1
MySQL: Text Date
, Text (Wed Apr 16 02:16:09 CEST 2008). Date ?
We are drowning in information, but starving for knowledge and time!
-
28th January 2009 08:43 #2Registered User
Join Date: Oct:2003
Location:
Posts: 4,317
-
28th January 2009 09:57 #3
, php :
Code:<? $date = "Wed Apr 16 02:16:09 CEST 2008"; echo date("Y.m.d", strtotime($date)); ?>Hey, mother, I come bearing a gift. I'll give you a hint. It's in my diaper and it's not a toaster.
.
-
28th January 2009 10:36 #4
. , Wed Apr 16 02:16:09 CEST 2008 . Date. T .
We are drowning in information, but starving for knowledge and time!
-
29th January 2009 11:53 #5
unixtime?
-
30th January 2009 13:59 #6
unixtime. , Date. BornToDrink .
We are drowning in information, but starving for knowledge and time!
-
30th January 2009 14:11 #7
, (
)
mysql , - .
Code:<? $sql = mysql_query("select `id`, `date` from `table`"); while ($date = mysql_fetch_array($sql)) { mysql_query("update `table` set `date` = '".date("Y.m.d", strtotime($date['date']))."' where `id` = '".$date['id']."'"); } ?>Hey, mother, I come bearing a gift. I'll give you a hint. It's in my diaper and it's not a toaster.
.
-
6th February 2009 14:25 #8
:
UPDATE `table` SET `dates1`=STR_TO_DATE(`dates_now`, 'my_format_here')
dates1 DATETIME, .
'my_format_here' , , , .
'%a %b %d %T ? %Y', CEST, .
DATETIME mysql, date/time - PHP.
(dates_now).




Reply With Quote
Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in