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

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 26 October 2023 16:38 PM UTC
  2. PowerBuilder
  3. # 1

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.
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 26 October 2023 10:21 AM UTC
  2. PowerBuilder
  3. # 2

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.
  • Page :
  • 1


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