Hacker News new | past | comments | ask | show | jobs | submit login

Should be %H:%i:%S?



%i is not an option. https://cloud.google.com/bigquery/docs/reference/standard-sq...

Looking it up it's only used in really old DBs.

...but that table reveals I should have used %M instead of %m. Whoops! Although in this particular case it doesn't make a difference. And apparently I can do "%F %X" instead of the whole string.


Yeah, just looked wrong, didn't check the docs




Consider applying for YC's Fall 2025 batch! Applications are open till Aug 4

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: