The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

The statement has been terminated.


Solution: guna data format : DD/mm/YYYY HH:mm:ss tt


INSERT into LCUlog(DateTime,logmessage) values ((convert(datetime,'1/14/2022 4:14:58 PM',103)), '');


Ulasan

Catatan popular daripada blog ini

SISTEM PENGOPERASIAN KOMPUTER (OS)

JENIS-JENIS SISTEM PENGOPERASIAN KOMPUTER

APA ITU ASCII (AMERICAN STANDARD CODE FOR INFORMATION INTERCHANGE) ?