search

sgtcortez / Termsequel

Bringing a portable SQL like syntax to our filesystem.
BSD 3-Clause "New" or "Revised" License
5 stars 1 forks source link

[Bug]: Date columns has a whitespace between date and time #91

Closed sgtcortez closed 2 years ago

sgtcortez commented 3 years ago

Contact Details

No response

What happened?

The result of dates, has an whitespace between the date and time, so, we can not compare this columns on where conditions.

Version

0.1 (Default)

What operating system are you seeing the problem on?

No response

Relevant log output

No response

Relevant print output

No response

sgtcortez commented 3 years ago

We shall use the 8601:2000 Interchange format to avoid confusions between users ....

Description of the ISO

Example: of use:

SELECT NAME, LAST_MODIFICATION

Returns: 

NAME     LAST_MODIFICATION
NAME1   2021-09-18T23:25:13