DBForge Studio is not handling DATETIME2 in MSSQL Server
CREATE TABLE #Table1 ( c1 int, c2 DATETIME2)
;
SELECT * FROM #Table1;
INSERT INTO #Table1 (c1,c2) VALUES (1, SYSUTCDATETIME ());
--dbforge returns: 7/29/2015 8:58:48 AM
--sqlstudio returns: 2015-07-29 09:00:32.5318459
-- we are missing the nanoseconds
1
vote
gianandrea
shared this idea
This can be setup as follows:
1. Select ‘Tools → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Data Editor → Formatting’ branch.
3. Select ‘DateTime’ from the ‘Data type’ dropdown menu.
4. In the ‘Predefined Formats’ list, select ‘General date/time (longtime with microseconds)’.
5. Click ‘OK’.