Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Format of XML data to import in to DateTime field?

Author  Topic  absjoe Starting Member 2 Posts Posted - 2009-11-05 : 01:05:30 Hi. I have been reading a lot about DateTime and SmallDateTime and think I understand the difference. I also appreciate how there is of course a difference between how the data is stored and how it is presented. But my question is actually about getting the data in to that field. I need to populate my database from an XML file where date/time is stored. Say I want to take the two XML tags of <date></date> and <time></time> and plug them in to a DateTime field in the database, how should the strings in these tags be formatted? Example: <record> <date>25-10-09</date> <time>12:45:02</time> </record> Will this lend itself to be populated nicely and cleanly in to the database? Thanks