date formatting

[Anon]

Does anyone know how to format a date to the format mask MMDDYYYY HH:MI:SS is SQL Server.

Thanks for your help!

[Anon]

you can format the date in that form with:

date('Y-m-d H:i:s');

hope this helps :-)

Chris Weeden

[Anon]

Chris,

I tried what you suggested, but got the error "date is not a known function name". Any other suggestions?

Thanks!

[Anon]

Can you show your code?

[Anon]

Here is the code that I used and I get no errors:
<code>
$date = <b>date('Y-m-d H:i:s');</b>
if(!(mysql_query("INSERT INTO nodes(node_name,node_category,node_date,node_author) VALUES ('$u_name Home','Home','$date',$row->user_id)",$link))){
$body .= "<h3>Error!!</h3>Database error. Couldn't INSERT new user home.";
}
else{
$body = "<h3>Success!!</h3>Your account has been added.";
$nrow_result = mysql_query("SELECT node_id FROM nodes WHERE node_author=$row->user_id AND node_category='Home'",$link);
if($nrow_result){
$nrow = mysql_fetch_object($nrow_result);
if(!(mysql_query("UPDATE users SET user_home=$nrow->node_id WHERE user_id=$row->user_id",$link))){
$body .= "<h3>Error!!</h3>Database error. Couldn't assign UPDATE home.";
}
$tpl->assign("META", "<meta http-equiv=refresh content=1;url=$site_url_base/node.php3?node=$nrow->
node_id>");
}
}
</code>

The field in the database is defined as such:

node_date datetime not null,