Results 1 to 8 of 8
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
http://www.google.com/search?q=mysql+date+conversion
íå âúðøè ëè ðàáîòà?
-
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 Ìîáèëíè êîìïþòðè