hello,
while trying to update products table using sql, getting the following error
INSERT INTO Nop_Product
(ShortDescription, CreatedOn, UpdatedOn)
VALUES ('This is a brand new product','25/07/2011 20:49:53', '25/07/2011 20:49:53')
"the conversion of varchar data type to a date time data type resulted in an out of range value"
getting the same error using getdate() instead of date values for CreatedOn and UpdatedOn Columns
also used MM/DD/YYYY format 07/25/2011 still getting the same error
createdon and updated on doesn't accept nulls.
Regards