formulahendry / formulahendry/vscode-mysql

CURRENT_DATE() display bug

Open
#94 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
TypeScript
Stars
229
Forks
58
PR merge metrics
No merged PRs in 30d

Description

when i insert to column set as date the CURRENT_DATE()
it is display as "2019-02-28T22:00:00.000Z"

INSERT INTO data (id, date, time, zone, type, value) VALUES ('asdf', CURRENT_DATE(), NOW(), 'asdf', 'asdf', 3)

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the shown INSERT statement in the VS Code MySQL extension and trace how the CURRENT_DATE() result is displayed. The issue is done when a value inserted into a date column is displayed as a date rather than the shown ISO timestamp.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql, typescript
Domain
database, devtools
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.