SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast hafez's Avatar
    Join Date
    Feb 2006
    Posts
    75
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    select date only from date time field

    hi
    if I have "Date Time" field , How can I get the Date only from this field.

    thanks.

  2. #2
    SitePoint Enthusiast
    Join Date
    Nov 2005
    Posts
    74
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    for example:
    Code:
    SELECT DATE_FORMAT(timestamp,'%M %D, %Y') FROM ...

  3. #3
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    select date(somefield) ...


Bookmarks

Posting Permissions

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