I have a flat file which is imported into SQL Server via an existing SSIS package. I need to make a change to the package to accommodate a new field in the flat file. The new field is a date field whi
I\'ve got a database with a table called Fio_FinalSched which in turn has a column named FinalDate with type smalldatetime. I convert the date string to a DateTime type by:
I have a textbox that should inserting a date in dd/MM/yyyy format. What only I can find and use is smalldatetime or datetime. I pick smalldatetime and the data displayed was like for example 01/07/20
My source table looks like this IdStartDate 1(null开发者_如何学JAVA) 212/12/2009 310/10/2009 I want to create a select statement, that selects the above, but also has an additional column to displa
I have a view th开发者_StackOverflow中文版at basically just returns all records from a table, and adds a column \'isodate\' which is supposed to be the date in ISO-Format.