nobody knows the answer

Anon

i tried about evey forum at the web for help' but no body gave a useful answer
i want to create a date in this format d/m/y
i do it like this: date('d/m/y',time())
but evry time i want to insert it into the DB it goes wrong.
i tried evry type at the DB (date,timestamo,int....)but the format that goes out from the db is somthing wird...
please help me' if u can give me a script it would be nice
thanks

[deleted]

which database are you using?

Anon

Do u need to have the format with forward slashes "/" ??? If you're using MySQL, its date formating is with dashes "-". Why don't u just try it this way:

//only do the bottom if u want the current date!!!
$today = mktime( 0,0,0, date("m"), date("d"), date("Y") );

$years = date( "Y", $today );
$days = date( "d", $today );
$months = date( "m", $today );

//u call the function like this:
$sql = "select from 'my_table' ";
$sql.= " '$years-$months-$days',";

u do an insert the same way.

Hope this helps. Its not exactly what i have used, but i just changed a few things.

good luck
tasneem

Anon

mysql

Anon

Go to following url it may help you

http://www.mysql.com/doc/D/a/Date_and_time_functions.html

Anon

but, if i do it that way' i cant do anything
with it, like:
if($today==$date)
{
print"this is today";
}
or somthing like that

Anon

i bleave it cant be happand

[deleted]

We know the answer alright, you just don't understand it.

Your table should contain a column of type DATE

the you can insert dates into it like this:

INSERT INTO table (date_column) values('2001-05-01');

YOu can get the dates back out by doing things like:

SELECT FROM table WHERE date_column > NOW();
SELECT FROM table WHERE MONTH(date_column)=2;
and a million more that are all described in the MySQL manual.

Anon

if you are trying to insert the current date into the database just do it on the DB level.

In SQL its getdate(), you simply predefine the value in the DB table, when your creating your table.