Issue with SQL Date Columns Splitting During IDEA Import

talebi

Forums

Hello,
I came across an issue while importing tables from an SQL database into IDEA. The problem is that IDEA automatically splits date columns into separate Date and Time columns. For example, if the column in SQL is DATE, after importing into IDEA it becomes DATE_DATE and DATE_TIME.
Could you please help me understand how to fix this during the import process?

Thanks,
Rouzbeh

Brian Element Fri, 11/28/2025 - 18:20

Hi Rouzbeh, 

I have seen this also happen when using ODBC drivers, which you probably are if you are importing from SQL.  If you need the date and time to be in one column then the option is to create a virtual field, change both the date and time into characters and then put the two fields together.  I don't think there is a way to have them come into IDEA as one field but maybe someone can show an example of how to do this.

Brian