Home > database >  Why always occurred in the 1900-1-1 pb 12.5 access server time?
Why always occurred in the 1900-1-1 pb 12.5 access server time?

Time:09-21

I use ORACLE as the database server, PB can read the database records, for the sake of time synchronization to write these sentences
Datetime ll
The select sysdate into: ll from dual;
Messagebox (" message ", string (ll))

The run results show message is 1900-1-1, the Internet a lot of examples, or didn't get the result,

CodePudding user response:

Prove that no Oracle connection
The 1900-1-1 is the date of the initial value

CodePudding user response:

See you connected to the server, if there is no connection so obtained should be the initial value, need to CONNECT USING the SQLCA. Finished to write SQL,

CodePudding user response:

Performs a select statement, take a look at the sqlca. Sqlcode return values, for the most part are failed
  • Related