Re: Formatting mysql timestamps the right way... - Paul DuBois - com.mysql.lists.java

4 messages in com.mysql.lists.javaRe: Formatting mysql timestamps the r...

From	Sent On	Attachments
Mads Søgaard	05 Mar 2000 11:43
Paul DuBois	05 Mar 2000 11:51
Tim Endres	05 Mar 2000 12:27
Mads Søgaard	05 Mar 2000 14:11

Subject:	Re: Formatting mysql timestamps the right way...
From:	Paul DuBois (pa...@snake.net)
Date:	03/05/2000 11:51:46 AM
List:	com.mysql.lists.java

At 8:43 PM +0100 2000-03-05, Mads S¯gaard wrote:

This is a pretty simple matter, but it has caused me quite a few problems, so please help me.

I'm having trouble formatting a date and time the right way. Could anyone please post a snippet of code that formats a mysql timestamp into something readable.

Don't make us guess. What do you want it to look like, and have you tried using the DATE_FORMAT() function in your SQL statement to make it look that way?