I'm using a sql select in VB 2005 to retrieve a DateTime field from a SQL Database. The value comes back like this in Query Analyzer: 2007-02-21 20:24:40.983 Is there a compatible data type in VB to hold this value in this format? My program updates a table that has this last_updated column. I need...

I am inserting data from a temporary table into my main "Users" table. One of the fields I am inserting from the temp table contains a "[Date Last Modified]" column in the format of "22/08/2007 22:41" but as a varchar(200) datatype as it was inserted via a bulk insert from...

Say I was born on June 1st, 2000. If anybody asked me, in any part of the world, when I was born I would say June 1st, 2000. I wouldn't say something like "Well, Im in Fiji now and I was born in Canada, so adjusted for time zone differecne I was born on June 2, 2000" or something like that...

hi there, I'm trying to format the date that I selecting from an xml document in sql server 2005. The date format I'm trying to insert into another table is (2007-01-04). the date format i'm getting from the document is (2002-09-27). I'm not sure how to cast the xml node as datetime....