opt time value display the debug sql #92
Merged
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
hello:
when the gorm debug sql,the time type display require a optimize.
when open a mysql connection with param "loc=Local".
And then execute sql,if set the time.Time utc,like this
t := time.Now() t = t.UTC() err = db.Table("test").Where("created_at>?", t).Find(&result).Error
the debug will show this
SELECT * FROM
testWHERE created_at>'2022-10-12 15:02:46.587'
but check the mysql general log,it exec this sql
SELECT * FROM
testWHERE created_at>'2022-10-12 23:02:46.5873415'
so if set the param “loc=Local”,when debug a sql,time zones also need to be considered,
Otherwise the print and the actual execution will be inconsistent and misleading.