Dear all I have a day, month, year, hour and minute and need to insert it into a database field with the format datetime in SQL Server 2000. Can anyone tell me how to achieve this, or even where in the Enterprise Manager I can find information on what format datetime is configured to? TIA Chris Marsh