Results 1 to 25 of 29

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Jun:2011
    Location: Ñîôèÿ
    Posts: 120

    Âúïðîñ çà Sql

    Èìàìå êîëîíà çà äàòà, â êîÿòî äàòàòà å êîäèðàíà è ñå âèæäà íèç îò ÷èñëà. Òèïà íà äàííèòå çà òàçè êîëîíà å èíòèæåð. Êàê äà èçâëåêà ñàìàòà äàòà îò òîçè íèç?

  2. #2
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location: Ïëîâäèâ
    Posts: 17,654
    Òîâà íå å ëè çà ðàçäåë Ïðîãðàìèðàíå?
    ×èñëà â êîëîíà çà äàòà îáèêíîâåíî å ñ öåë îïòèìèçèðàíå íà ðàçëè÷íè íèâà, àêî ãîâîðèø çà PHP/mysql (è íå ñàìî), îáèêíîâåíî ñå ïàçè unix timestamp, è ìîæåø äà ïîëçâàø ôóíêöèè êàòî date('format_chars', 12345678);
    (çàìåñòâàø ïàðàìåòðèòå ñúñ ñúîòâåòíèòå íåùà).

  3. #3
    Registered User
    Join Date: Jun:2011
    Location: Ñîôèÿ
    Posts: 120
    À ñ êàêâî ïî-òî÷íî çàìåñòâàì òåçè äâà ïàðàìåòúðà âúâ ôóíêöèÿòà? Ñòàâà âúïðîñ çà òîâà äà èçêàðàì äàííèòå îò åäíà sql-òàáëèöà. Åäíà îò êîëîíèòå â çàÿâêàòà å òàçè çà äàòàòà.

  4. #4
    Registered User PepiX's Avatar
    Join Date: Sep:2004
    Location: Ñîôèÿ
    Posts: 13,376
    Ïðèìåð: Format(rs!DateField, "Short Date") èëè Format(rs!DateField, "dd/mm/yyyy")

    êúäåòî rs å recordset â êîéòî ñà èçòåãëåíè äàííè îò òàáëèöàòà à DateField å èìåòî íà ïîëåòî..

    èëè ïúê: Select Format(DateField, 'dd/mm/yyyy') From TableHoldingDate

    àêî ðåøèø äà å ÷àñò îò çàÿâêà (DateField è TableHoldingDate òðÿáâà äà ãè çàìåñòèø ñ ðåàëíèòå èìåíà)

    Ñòðàííî å, ÷å íå å çàïàçåíà äàòà è ÷àñ (òîåñò òèï float/double) àìè ñàìî ÷àñòòà ñ äàòàòà (integer/long..)

  5. #5
    Registered User
    Join Date: Jun:2011
    Location: Ñîôèÿ
    Posts: 120
    Òîâà ñ ðåêîðäñåòà íå ãî ðàçáðàõ. Òðÿáâà ìè íåùî, êîåòî äà ïî÷âà ñ Select 1-âà êîëîíà.... from òàáëèöàòà

  6. #6
    Registered User PepiX's Avatar
    Join Date: Sep:2004
    Location: Ñîôèÿ
    Posts: 13,376
    Quote Originally Posted by saho87 View Post
    Òîâà ñ ðåêîðäñåòà íå ãî ðàçáðàõ. Òðÿáâà ìè íåùî, êîåòî äà ïî÷âà ñ Select 1-âà êîëîíà.... from òàáëèöàòà
    Ñ ðåêúðäñåòà å àêî ùå ãî ïîëçâàø â êîä.. â ïîñëåäñòâèå âèäÿõ êàêâî òî÷íî èñêàø è äîáàâèõ ïðèìåðà çà çàÿâêà..

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 | Ìàãàçèí çà åëåêòðîííè öèãàðè