Using Date() funttion

solconsult

Dear Sir,

I am using PHP and MYSQL to develop Dynamic website. I want to insert data in to a table.

Example:

$date = date('Y-m-d hⓂs');

This function reads the system date and time. It works with out any problem.

But the 'm' in the date function reads only month. In the other way round, this function can't read month.

2002-11-19 08:11:53

Can you help me
Thank you

rIkLuNd

If you want it to show date and time, then you hvae to do like this:

<?php

$date = date('Y-m-d h:i:s');

?>

planetsim

this may mean nothing to you but i suggest use double quote " " in date() and other functions in php that require quotes...

bretticus

Unless you're really worried about getting the system time on the Web server, just use MySQL timestamps.

If a table has a column with timestamp datatype, you can basically ignore putting anything about dates in your insert query.

If you need to retrieve the date data use UNIX_TIMESTAMP(timestamp_column) in your SELECT query.

Weedpacket

Originally posted by planetsim
this may mean nothing to you but i suggest use double quote " " in date() and other functions in php that require quotes...

Why?