Microsoft SQL inserting dates

[Anon]

Hi,

Can anyone help me with a small query.

I have a field in a microsoft sql 2000 database which is the format datetime

i want to post some formdata which is in the format dd/mm/yyyy when ever i use the php script to insert the data, it remains blank.

Any ideas anyone?

Many Thanks

[vanpoeck]

You can try inserting a string like this: '30/07/2002'. Also check what locale your MS SQL database is in (go have a look in the table to see how the dates are being written: US or other formats).

If you've already done all that, hop us your SQL code, that might give us a hint 🙂

HTH,
Steven

[Anon]

okay the code is as follows ;

nothing special just some drop down boxes to pick a date!

$initiated_day = "22" ; // actually 3 drop down boxes supplying the data
$initiated_month = "11" ;
$initiated_year = "2002" ;

// perform some date stuff!

$project_date_initiated = "$initiated_day/$initiated_month/$initiated_year" ;

echo "<br>$project_date_initiated<br>" ;

// create connection
$connection = mssql_connect("$user_database_server","$user_database_write_user","$user_database_write_pass")
or die("Couldn't make connection.");

// select database
$db = mssql_select_db("$projects_database", $connection)
or die("Couldn't select database.");

// create SQL statement
$sql = "INSERT into $projects_table (project_description,
project_location,
project_sponsor,
project_manager,
project_initiator,
project_date_initiated)
values ('$project_description',
'$project_location',
'$project_sponsor',
'$project_manager',
'$project_initiator',
'$project_date_initiated')" ;