Problems using myphpadmin to display dates within tables in Joomla.

Discussion in 'Joomla' started by pbspeedy, Mar 23, 2011.

0
  1. #1
    Hi,

    I'm importing a dataset (currently stored in Excel as a .xls) file into my Joomla website to display in a table. I'm uploading this data into MyPHPAdmin and then from there it is being displayed in the table via an SQL query.

    So the Excel file contains dates, these are stored in a date format (dd/mm/yyyy). The problem is that when they are imported into the database all the dates blank themselves to appear as '00-00-00 00:00:00'. I've tried to change how they are stored in MyPHPAdmin (i.e. I've tried changing the field to: DATE, DATETIME, TIMESTAMP, TIME, YEAR, FLOAT& DOUBLE) with no luck.

    Any ideas where I am going wrong?????

    Thanks,

    Paul
     
    pbspeedy, Mar 23, 2011 IP
  2. ama

    ama Greenhorn

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #2
    I'm pretty sure MySQL uses the format yyyy-mm-dd
     
    ama, Apr 16, 2011 IP