1. Santosh Natal
  2. PowerBuilder
  3. Thursday, 26 October 2023 10:13 AM UTC

I have a datawindow for report which has an argument of datatype DATETIME, and datasource as SQL Server 2019. The argument is related to table column of datatype datetime2. When I try to retrieve the report, I get an error as :

image

When I try to convert the argument datatype of DATETIME using CAST or CONVERT functions, I get the error as below :

 

I am pretty much stuck over here and getting any solution.

 

Does anyone know this issue?

 

Thanks and regards,

Santosh Natal

Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 26 October 2023 10:21 AM UTC
  2. PowerBuilder
  3. # 1

I think it has to do with the millisecond settings.

Do this search and you might find some clarification: https://www.appeon.com/standardsupport/search?comments=datetime2&product=&component=&criteria=and&order=

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 26 October 2023 16:38 PM UTC
  2. PowerBuilder
  3. # 2

Hi Santosh ;

  Unfortunately, the DateTime2 data type is still not supported in the latest PB versions.  :-(

  However, I would suggest that you try some type of workaround (as an example) ...

https://community.appeon.com/index.php/qna/q-a/how-do-people-work-around-datetime2-data-type-in-mssql

HTH

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.