I input the date in the PB type: dd - mm - yyyy, but date of SQL type to a datetime. I input the date in the PB, such as the 06-08-2008, but the deposit to the SQL database according to the 01-01-1990 00:00:00. Who can tell me how to SQL in the dd - mm - date yyyy format.
Thank you first!

CodePudding user response:

2008-08-06 00:00:00

CodePudding user response:

Enter '2008-08-06'

CodePudding user response:

The 2008-08-06

CodePudding user response:

If type in PB also datatime, as well as in the database!
Dd - mm yyyy just display format, and store has nothing to do!
What show do you use the style is fine, the database is a standard format!

CodePudding user response:

No matter how much I lose, deposited in the database is the 1900-01-01 this value. This is why?

CodePudding user response:

That is DW has a problem

CodePudding user response:

1. Make a list of the database to empty, clear as a null
2. The form of the reality of the dw into "yyyy - mm - dd"
3. Enter '2008-12-12'
4 the update

CodePudding user response:

Did you use the DW remaining, have accepttext ()

CodePudding user response:

The column names in your data window properties, select the 'format' input dd - mm yyyy