How the date Value displayed as dd-mm-yy instead of 1187962147 in PHPMyAdmin?

Author Name Status Posted Time Poicramuikri Cevilto 5/9/2008 1:57:15 AM Author is Offline Hey all, It's my first post here and I'm also a Mysql noob, but I know a few things, just not this...   The rest is in the next post

Subject Author Status Date Re: How the date Value displayed as dd-mm-yy inste ad of 1187962147 in PHPMyAdmin? Poicramuikri Cevilto 5/11/2008 11:39:46 PM I have a table that has the following structure: Field = timevalue Type= varchar(12) Value = 1187962147 I'd like to see the date Value displayed as dd-mm-yy instead of 1187962147 in PHPMyAdmin. How? TIA! Post Comments Re: How the date Value displayed as dd-mm-yy inste ad of 1187962147 in PHPMyAdmin? Dan D'Souza 5/11/2008 11:41:14 PM Okay, first of all, you should be using INTEGER, not VARCHAR to display a unix epoch number as a date, use the FROM_UNIXTIME function might not work on a string, but maybe mysql will convert it implicitly Post Comments Re: I did that and got error Poicramuikri Cevilto 5/11/2008 11:42:30 PM Hey Dan, I did that and got this error: Quote: tbl_replace.php: Missing parameter: goto (FAQ 2.8) Post Comments Re: Move this thread to PHP? Dan D'Souza 5/11/2008 11:44:13 PM Okay, would you like me to move this thread to the php forum? Post Comments Re: Ok sure Poicramuikri Cevilto 5/11/2008 11:45:10 PM ok sure. Thanks Post Comments Re: How the date Value displayed as dd-mm-yy inste ad of 1187962147 in PHPMyAdmin? Sardha Henry 5/11/2008 11:47:17 PM If you're using PHPMyAdmin you're going to have to convert it using the SQL syntax, however if you intend to extra the information from MySQL first then parse it in your own PHP script then consider using: Code: $date = '1187962147'; $date = date('d-m-Y', strtotime($date)); echo $date; Post Comments Re: Thanks all Poicramuikri Cevilto 5/11/2008 11:50:20 PM Thanks all. Quote: store a date as a date Right, I have no idea why the devs who designed the db used that system for the date. Post Comments Re: Somebody told them that integers were more eff icient Dan D'Souza 5/11/2008 11:52:55 PM Somebody told them that integers were more efficient, and they drank the koolaid Post Comments Re: How the date Value displayed as dd-mm-yy inste ad of 1187962147 in PHPMyAdmin? Mocco Tokkendo 5/11/2008 11:47:54 PM Sounds like a good reason to revisit the dsign of the db and fix the problem in the first place .. store a date as a date and be doen with the problem. Post Comments

Related Forums Optimizing Images Get a Website Template for Free!!! Get a Website Template for Free!!! Reply to Hesus!!! Do You Sell Your Templates on Ebay?