how to show date time as dd/mm/yyyy hh:mm:ss instead of GMT format

formulahendry / vscode-mysql

MySQL management tool for Visual Studio Code

https://marketplace.visualstudio.com/items?itemName=formulahendry.vscode-mysql

MIT License

218 stars 59 forks source link

how to show date time as dd/mm/yyyy hh:mm:ss instead of GMT format #187

Open ongkokl opened 2 years ago

ongkokl commented 2 years ago

When i run a SQL query the date column will show as GMT format as below. How to set default as dd/mm/yyyy hh:mm:ss format instead?

Thanks

chrisazack commented 2 years ago

this is actually a huge problem that I just encountered. It is assuming a timezone based on a datetime even when there isn't one set at all. Should only be displaying the RAW data