Big Query pars_timestamp issue

Question

I'm trying to use Pars_Timestamp function in Standard SQL and it parses with no differentiation between Am and PM below is my query and the result of both are the same which is not correct;

SELECT
  PARSE_TIMESTAMP("%B %e, %Y %l:%M %p",time)
FROM ( 
  SELECT
    'May 14, 2018 9:46 AM' AS time
  UNION ALL
  SELECT
    'May 14, 2018 9:46 PM' AS time )

Mikhail Berlyant · Accepted Answer · 2018-05-15 01:23:03Z

2

 PARSE_TIMESTAMP("%B %e, %Y %I:%M %p",time)

You can try it with your dummy data as

#standardSQL
SELECT
  PARSE_TIMESTAMP("%B %e, %Y %I:%M %p",time)
FROM ( 
  SELECT
    'May 14, 2018 9:46 AM' AS time
  UNION ALL
  SELECT
    'May 14, 2018 9:46 PM' AS time )

this will give you

05/14/2018 09:46:00
05/14/2018 21:46:00

edited May 15, 2018 at 1:23

answered May 14, 2018 at 23:23

Mikhail Berlyant

174k10 gold badges173 silver badges251 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Big Query pars_timestamp issue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related