how insert datetime using now.tostring for sql DB datetime - dataType " UPDATE [DBl].[dbo].[CompanySummary] SET [Attempts] = [Attempts]+1, [Status] = ‘Y’ ,[Attachment_Validated_status] =‘Y’ , [AttachementValidated_Date_time] =(convert(datetime,'“+now.ToShortTimeString+”,5)) [Rejected_Reason] = …

How to insert datetime in sql query by now.tostring

sandeep_sonu (sandeep B) March 1, 2021, 10:54am 2

[AttachementValidated_Date_time ] = Format(GETDATE(),‘yyyy-MM-dd’)
Can you try the above

Topic		Replies	Views
SQL Insert DateTime object into Date column Help	2	2092	January 10, 2020
Cant using datetime in database query Community activities , studio , question , community	6	1157	December 21, 2022
Problem with datatype while updating the database Help	7	3372	October 29, 2018
How to convert String to Date and Insert in DB Activities uiautomation , activities	3	1776	May 27, 2021
SQL accepts this format for datetime yyyy-MM-dd HH:mm:ss and I am getting MM/dd/yyyy HH:mm:ss format Solution Accelerators	2	189	September 25, 2024