Null date columns display as 1/1/0001

bobtreu · Post by **bobtreu** » Sat 21 Jan 2012 03:13

I have database rows that contain date columns that are empty ( no data for the cell) yet dbForge displays the value as 1/1/0001.

Other date columns contain data formatted YYYYMMDD, yet they are displayy as m/d/yyyy

I need a way to turn off formatting and see what is actually in the row.
I have not found a setting to do it yet.

I'll try to attach an image. (Can't do it )

alexa · Post by **alexa** » Mon 23 Jan 2012 10:13

I have database rows that contain date columns that are empty ( no data for the cell) yet dbForge displays the value as 1/1/0001.

Such a situation may occur when the 'Allow nulls' option is selected against the column in the 'Column Properties' dialog box. In this case the DATE fields are automatically set to '1/1/0001' which is the minimum date predefined in .NET Framework. Please note that if the 'Allow nulls' option is selected against the column, default values are not inserted.

Other date columns contain data formatted YYYYMMDD, yet they are displayy as m/d/yyyy
I need a way to turn off formatting and see what is actually in the row.
I have not found a setting to do it yet.

To make the DATE fields to be formatted as you specified, please follow the procedure:
1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Data Editor -> Formatting' branch.
3. Select 'Date' from the 'Data type' dropdown menu.
4. In the 'Edit Format' field, enter the following: yyyy/MM/dd