Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Date should not be truncated #389

Open
dvanmali opened this issue Aug 21, 2024 · 0 comments
Open

Date should not be truncated #389

dvanmali opened this issue Aug 21, 2024 · 0 comments
Labels
bug Something isn't working

Comments

@dvanmali
Copy link

dvanmali commented Aug 21, 2024

Describe the bug
Truncating the date string into milliseconds without the nanoseconds, prevents us from querying the record since the entire timestamp is recorded. The query works within SurrealDB but since the format is slightly off, this prevents us from obtaining specific record data.

To Reproduce
Steps to reproduce the behavior:

  1. Create a test record with a complex id of a timestamp inside Surrealist. Note the id.
    CREATE ONLY Test:[time::now()] SET data="some data"
  2. Run the select statement in the surreal CLI on the specific record. Note the id here.
    SELECT * FROM Test
  3. Compare ids. The precision of the id prevents us from querying the id on the database.
    SELECT * FROM $testId

Expected behavior
The full string for the date should be displayed. This should occur in all datetime display locations(ie query result, id inputfield). If users wish for a shorter format, the user should have the data itself be represented by fewer digits (ie. use time::round(datetime, 1ms)).

Environment:
Screenshot 2024-08-20 at 5 03 56 PM
Screenshot 2024-08-20 at 5 03 15 PM
Screenshot 2024-08-20 at 5 03 37 PM

@dvanmali dvanmali added the bug Something isn't working label Aug 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant