Help: Unable to retrieve Date columns from database
Using a DataSource to attempt to retrieve a couple of fields from the sql database using the com.microsoft.sqlserver.jdbc.SQLServerDriver.
I have to properties create EmployeeName, BeginDate & EndDate
Sample SQL Query
Select NameEmployee as EmployeeName, DateBegin as BeginDate, DateEnd as EndDate
From Job
Where EmployeeNumber = 'xyz'
The name comes back just fine, but the dates properties are empty. The dates in the Sql Server DB are populated (2011-02-10 00:00:00.000).
Any Help is greatly appreciated.
I have to properties create EmployeeName, BeginDate & EndDate
Sample SQL Query
Select NameEmployee as EmployeeName, DateBegin as BeginDate, DateEnd as EndDate
From Job
Where EmployeeNumber = 'xyz'
The name comes back just fine, but the dates properties are empty. The dates in the Sql Server DB are populated (2011-02-10 00:00:00.000).
Any Help is greatly appreciated.
