1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

database date format

Discussion in 'Databases' started by daboss, Mar 29, 2007.

0
  1. #1
    when i look at the vb3_user table for a vbulletin forum, i notice that the joindate field has values in the form of "1174753712". how do i convert this into a normal human understandable date - e.g. "3-Mar-07"

    thanks in advance for any help that you may provide.
     
    daboss, Mar 29, 2007 IP
  2. maiahost

    maiahost Guest

    Messages:
    664
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    0
    #2
    maiahost, Mar 29, 2007 IP
  3. daboss

    daboss Guest

    Messages:
    2,249
    Likes Received:
    151
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thanks... anyone else got suggestions?
     
    daboss, Mar 29, 2007 IP
  4. maiahost

    maiahost Guest

    Messages:
    664
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    0
    #4
    OK let me try again :
    Get the data from your database and : 
    
echo date("d-M-y",$datevar);
    PHP:
     
    maiahost, Mar 29, 2007 IP