Discussions tagged DATETIME
PB Support for Datetime and Datetime2 in SQL Server
- Issue
- Last updated 7 months ago
- Larry Pettit replied 3 months ago
Please forgive me if any of my statements below are not correct! That's one of the reasons I'm writing this post, to get informed about the current status and clear up any misconceptions on my part.
Since Microsoft SQL Server 2016, the Datetime data...
RestClient string to datetime
- Resolved
- How-to
- Last updated 2 years ago
- Kevin Ridley replied 2 years ago
Hi.
I've created a datawindow and using RestClient.retrieve(dw,URL) to fetch data from our API. Works great.
However, there is a small issue regarding datetime and strings.
This is the string in the JSON responsebody containing the datetime: "m...
DB2 TimeStamp Retrieval Argument
- How-to
- Last updated 3 years ago
- Chris Pollach @Appeon replied 3 years ago
Hi all,
I have a program that must be able to retrieve data based on the previous day's "Approved Date." I am using PowerBuilder 2017 and I am accessing a DB2 database. The only retrieval argument in my query is of DateTime type (see query attache...
Determine Regional Settings on Mobile Device
- Resolved
- How-to
- Last updated 6 years ago
- Michael Hartnett replied 6 years ago
Hi All,
Not sure if this has been asked before, but struggling to find direction on what to do.
Is there a way to determine the Language & Region and therefore the Date & Time format used on a mobile device using Powerserver Mobile.
We have an app...
Powerserver error on date of datawindow
- Issue
- Last updated 6 years ago
- Marco Meoni replied 6 years ago
Hi all
I have a app on power builder 2017R2, i have a column date when i test on desktop it works but when i deployed to poderserver the column date give me error No Pass Validation, Any suggest? ...
Datetime field overflow when using SQL native driver 10 or 11
- Issue
- Last updated 6 years ago
- Govinda Lopez @Appeon replied 6 years ago
My application connects to SQL 2012 via ODBC. When I configure the ODBC source to use a SQL Server Native Client driver (either 10 or 11), I get errors with the smalldatetime fields in the database. It works fine with just the SQL Server driver, al...
How to fix datetime data type conversion while datawindow is in querymode?
- Issue
- Last updated 7 years ago
- FILI SOSA replied 7 years ago
Our program has DataWindows with DateTime fields and we allow the user to Query for information with QueryMode; one button turns QM on and another button causes it to Retrieve with the information the user put in.
Our datetime fields have the foll...
- Page :
- 1