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

Getting current timestamp with nanosecond precision #2

Open
SteelBlueVision opened this issue May 31, 2021 · 2 comments
Open

Getting current timestamp with nanosecond precision #2

SteelBlueVision opened this issue May 31, 2021 · 2 comments

Comments

@SteelBlueVision
Copy link

SteelBlueVision commented May 31, 2021

Hi Floris, this codebase should really get extended with the ability to do something similar to:

SELECT CURRENT_TIMESTAMP;

..., (i.e., get the time now with nanosecond precision, which I realize is OS specific). If you would like, I can implement this for Windows/Linux and submit a pull-request, but I may have questions for you along the way.

@fvannee
Copy link
Collaborator

fvannee commented May 31, 2021

I'd be happy to review a PR for a function like that. The pg function is now() so perhaps a function like nsnow()? Happy to accept a better name though.

@higuoxing
Copy link
Contributor

Hi, I've created a PR (#7) to support this feature. But I didn't implement it for Windows platform, it would be good to get some comments from both of you :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants