I am very new to this so I apologize if I get confusing with my post.
I have a database that I access through CPanel then through phpMyAdmin. I am running a query to find out when the last login was made by users and I am getting values such as '1233345786' returned.
I need to be able to convert this integer value to a date value of 'MM/dd/yyyy'. When I try
SELECT date_format(`user_lastvisit`, '%d %m %Y')
the field is returning NULL as the value. When I try Convert_Date the query returns an error saying my table does not contain this function.
And just to clarify further, I can see the correct dates when viewed via my PHP plugin but when I run it via SQL from the database backend that is when I am getting my error. I need to be able to see this from the backend as well because I believe my PHP code for the plugin that I created is flawed.
Can anyone help? I am running out of options.