datetime into 12-hour clock

[markman641]

hello, im using the datetime NOW() function to insert the time into my databases, but it puts it in a strange format, it outputs

2011-08-25 02:09:29

when it would be a lot better if it outputted

8/25/11 7:00 PM

How would I do that? this is my code:

mysql_query("INSERT into completed (username, name, rate, time) VALUES ('$snuid', '$campname', '$points', NOW())");

and if the only way to do that is to output it into separate columns, what would i put in the values?

[Nightfire]

Take a look at date_format()

[markman641]

ok i looked, how do i implement that? '%c %e %y %r'

[Nightfire]

Yep, just add the slashes etc wherever you want them

[markman641]

i know that, but how would i put it in my code?

[Nightfire]

If you have datetime in the mysql field, that's the only format you can use in that field.
You can only format it on the select query, which is shown on the link I gave

SELECT DATE_FORMAT('time','%c %e %y %r') FROM blah

[markman641]

<?
				$get_name = mysql_query("SELECT DATE_FORMAT('time','%c/%e/%y %r') `username`, `name`, `rate` FROM `completed` WHERE username='$usr'");
 while($namerow = mysql_fetch_array($get_name)) {
	$date = $namerow["time"];
  	$username = $namerow["username"];
  	$offername = $namerow["name"];
	$amount = $namerow["rate"];
?>

doesnt work, sorry im really confused idk where to put anything

[Nightfire]

$get_name = mysql_query("SELECT DATE_FORMAT('time','%c/%e/%y %r') as time, `username`, `name`, `rate` FROM `completed` WHERE username='$usr'"); 

Showing the error helps, instead of 'doesn't work'.

You missed a comma, and I thought I'd make it a bit easier to follow by adding the 'as time' in too. That should work now.

[markman641]

its just showing blank. do i have to change the way its inputted and/or my database? i have the string set as datetime?

[kbluhm]

http://www.php.net/date

http://www.php.net/strtotime

$datetime = '2011-08-25 02:09:29 ';

echo date( 'n/j/y, g:i A', strtotime( $datetime ) ); // 8/25/11 2:09 AM 

[markman641]

now where would i put that? the insert page or the result page? where on there?

[markman641]

got it to work. ended up doing:

<?
				$get_name = mysql_query("SELECT `time`, `username`, `name`, `rate` FROM `completed` WHERE username='$usr'");
 while($namerow = mysql_fetch_array($get_name)) {
  	$username = $namerow["username"];
  	$offername = $namerow["name"];
	$amount = $namerow["rate"];
	$datetime = $namerow["time"];



?>


<tr>
<td><?=$offername?></td>
<td><?=$amount?></td>
<td><? echo date( 'n/j/y, g:i A', strtotime( $datetime ) ); ?></td>
</tr>
<? }?>

[markman641]

it seems like the times are off by 4 hours, how do i fix that?

[rose_developer]

Hi,

try this,
<?php

$mytime = date("m/d/Y h:i:s",time());

mysql_query("INSERT into completed (username, name, rate, time) VALUES ('$snuid', '$campname', '$points', '$mytime')");

?>

hello, im using the datetime NOW() function to insert the time into my databases, but it puts it in a strange format, it outputs when it would be a lot better if it outputted

How would I do that? this is my code:

mysql_query("INSERT into completed (username, name, rate, time) VALUES ('$snuid', '$campname', '$points', NOW())");

and if the only way to do that is to output it into separate columns, what would i put in the values?

[markman641]

not what i was asking at all, its just that the hours are off