Results 1 to 8 of 8

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Eclipse Plugin Developer aphex's Avatar
    Join Date: Mar:2003
    Location: Karlsruhe
    Posts: 546

    Question MySQL: ïðåîáðàçóâàíå íà Text â Date

    Èìàì äàííè â åäíà áàçà äàííè, êîèòî ñà çàïèñàíè ïîä òèï Text (Wed Apr 16 02:16:09 CEST 2008). Êàê ìîãà äà ãè ïðåîáðàçóâàì îò òèï Date ?
    We are drowning in information, but starving for knowledge and time!

  2. #2
    Registered User
    Join Date: Oct:2003
    Location: Ñîôèÿ
    Posts: 4,317
    http://www.google.com/search?q=mysql+date+conversion
    íå âúðøè ëè ðàáîòà?

  3. #3
    hmm BornToDrink's Avatar
    Join Date: Aug:2005
    Location: Â. Òúðíîâî
    Posts: 11,573
    Íå ðàçáðàõ òî÷íî êâî ñå îïèòâàø äà íàïðàâèø, íî åòî òè 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.
    Ïëàíèíà.áã

  4. #4
    Eclipse Plugin Developer aphex's Avatar
    Join Date: Mar:2003
    Location: Karlsruhe
    Posts: 546
    Èìàì åäíà êîëîíà îò òèï òåêñò â êîÿòî ñà çàïèñàíè äàòè. Ïðîáëåìà å, ÷å ñà â Wed Apr 16 02:16:09 CEST 2008 ôîðìàò è íå ìîãà äà ñîðòèðàì çàïèñèòå ïî äàòà. Çàòîâà èñêàì äà êîíâåðòèðàì òàçè êîëîíà äà áúäå â òèï Date. Tàêà ùå ìîãà äà ìàíèïóëèðàì ôîðìàòà íà äàòàòà è ùå ìîãà äà ïîäðåäÿ èíôîðìàöèÿòà õðîíîëîãè÷íî.
    We are drowning in information, but starving for knowledge and time!

  5. #5
    The Lord of the Death altoas's Avatar
    Join Date: Jun:2006
    Location: varna
    Posts: 315
    unixtime?

  6. #6
    Eclipse Plugin Developer aphex's Avatar
    Join Date: Mar:2003
    Location: Karlsruhe
    Posts: 546
    íå å unixtime. Ïðîñòî äàòàòà å ñòðèíã, à ìè òðÿáâà äà ÿ êîíâåðòèðàì â òèï Date. Ôóíêöèÿòà íà BornToDrink ùå ìè ñâúðøè ðàáîòà. Áëàãîäàðÿ çà âíèìàíèåòî
    We are drowning in information, but starving for knowledge and time!

  7. #7
    hmm BornToDrink's Avatar
    Join Date: Aug:2005
    Location: Â. Òúðíîâî
    Posts: 11,573
    Åòî åäíî ñêðèïò÷å, ñàìî òðÿáâà äà ñå ñëîæè èìåòî íà òàáëèöàòà è åäíà êúíåêöèÿ ãîðå ( è äà ñå òåñòâà )
    Ìú÷èõ ñå äà èçìèñëÿ íåùî ñàìî ñ 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.
    Ïëàíèíà.áã

  8. #8
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location: Ïëîâäèâ
    Posts: 17,654
    Ñ åäíà çàÿâêà:

    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).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 Õàðäóåð ÁÃ. Âúçìîæíî å ñúäúðæàíèåòî íà òàçè ñòðàíèöà äà å îáåêò íà àâòîðñêè ïðàâà.
iskamPC.com | mobility.BG | Bloody's Techblog | Êðèïòîâàëóòè è ìàéíèíã | 3D Vision Blog | Ìàãàçèí çà åëåêòðîííè öèãàðè