22
Hi All,
I'm trying to insert a record into the pm10200 and i get the following error
conversion failed when converting date and /or time from character string
This is the format I'm using '2022-12-21 00:00:00.000'
i tried a couple different formats as well , but i got the same error... any help would be greatly appreciated.
Glad to help. Please mark my reply as the answer.
Hi Richard,
That worked.. thanks for the assist!
I believe it is complaining about TIME1.
Try inserting '1900-01-01 00:00:00.000'
HI Richard,
Share
Report
All responses (
Answers (
USE [TEST]
GO
INSERT INTO [dbo].[PM10200]
([VENDORID]
,[DOCDATE]
,[DATE1]
,[GLPOSTDT]
,[TIME1]
,[APTVCHNM]
,[APTODCTY]
,[APTODCNM]
,[APTODCDT]
,[ApplyToGLPostDate]
,[CURNCYID]
,[CURRNIDX]
,[APPLDAMT]
,[DISTKNAM]
,[DISAVTKN]
,[WROFAMNT]
,[ORAPPAMT]
,[ORDISTKN]
,[ORDATKN]
,[ORWROFAM]
,[APTOEXRATE]
,[APTODENRATE]
,[APTORTCLCMETH]
,[APTOMCTRXSTT]
,[VCHRNMBR]
,[DOCTYPE]
,[APFRDCNM]
,[ApplyFromGLPostDate]
,[FROMCURR]
,[APFRMAPLYAMT]
,[APFRMDISCTAKEN]
,[APFRMDISCAVAIL]
,[APFRMWROFAMT]
,[ActualApplyToAmount]
,[ActualDiscTakenAmount]
,[ActualDiscAvailTaken]
,[ActualWriteOffAmount]
,[APFRMEXRATE]
,[APFRMDENRATE]
,[APFRMRTCLCMETH]
,[APFRMMCTRXSTT]
,[PPSAMDED]
,[GSTDSAMT]
,[TAXDTLID]
,[POSTED]
,[TEN99AMNT]
,[RLGANLOS]
,[APYFRMRNDAMT]
,[APYTORNDAMT]
,[APYTORNDDISC]
,[OAPYFRMRNDAMT]
,[OAPYTORNDAMT]
,[OAPYTORNDDISC]
,[Settled_Gain_CreditCurrT]
,[Settled_Loss_CreditCurrT]
,[Settled_Gain_DebitCurrTr]
,[Settled_Loss_DebitCurrTr]
,[Settled_Gain_DebitDiscAv]
,[Settled_Loss_DebitDiscAv]
,[Revaluation_Status]
,[Credit1099Amount]
,[DEFTEN99TYPE]
,[DEFTEN99BOXNUMBER])
VALUES
( 'ED15 ',
'2022-12-21 00:00:00.000',
'2023-05-31 00:00:00.000',
'2023-05-31 00:00:00.000',
'1',
'00000000000189315',
'1',
'53031933',
'2023-03-03 00:00:00.000',
'2023-03-15 00:00:00.000',
'Z-US$ ',
'1007',
'27',
'0',
'0',
'0',
'27',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'00000000000140374',
'5',
'50665938',
'2023-12-28 00:00:00.000',
'Z-US$ ',
'27',
'0',
'0',
'0',
'27',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
' 0 ',
'1',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'1',
'0')
GO
Thanks for your response.
Here you go!
Please reply with your code. That is the correct format. The SQL definition of date is datetime.
#1
André Arnaud de Cal...
291,735
Super User 2024 Season 2
#2
Martin Dráb
230,466
Most Valuable Professional
#3
nmaenpaa
101,156
