Home Forums SQL Server 2005 T-SQL (SS2K5) DataType Issue in SQL 2005! RE: DataType Issue in SQL 2005!
dragos_sv
Default port
Points: 1478
More actions
February 22, 2008 at 2:10 am
#780987
hi
if you must store the data in that format, use a column type char(23) with default value: convert (char(23), getdate(), 121)
hope i understood your requirement right and that the solution works for you
dragos