in bigquery i have STRING column which has value 2024/2/9 23:52:05 GMT+07:00, raw date without a leading zeros, sometimes i got 2024/12/10 20:51:05 GMT+07:00, is it possible to convert this column into a new timestamp column since i cannot using format timestamp with %Y-%m-%d %H:%M:%S %Z
Bigquery, converting uncommon STRING to TIMESTAMP
37 Views Asked by lifetolearn22 At
1
There are 1 best solutions below
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in GOOGLE-BIGQUERY
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- SELECT AS STRUCT/VALUES
- Google Datastream errors on larger MySQL tables
- Can i add new label called looker-context-look_id in BigQuery connection(Looker)
- BigQuery external table using JSON files
- Does Apache Beam's BigQuery IO Support JSON Datatype Fields for Streaming Inserts?
- sample query for review for improvement on big query
- How does Big Query differentiate between a day and month when we upload any CSV or text file?
- How to get max value of a column when ids are unique but they are related through different variables
- how to do a filter from a table where 2 different columns has 2 different records which has same set of key combinations in bigquery?
- How to return a string that has a special character - BigQuery
- How do I merge multiple tables into a new table in BigQuery?
- Customer Churn Calculation
- Is it correct to add "UNNEST" in the "ON" condition of a (left) join?
Related Questions in BIGQUERY-UDF
- Running Total UDF ( user defined function ) with a window function is throwing 'Failed to coerce output value ''
- Decoding url (Unicode to UTF-8) in Bigquery /Python
- GCP Dataflow Batch MongoDB to BigQuery error schema does not match field changed type from TIMESTAMP to STRING
- Bigquery, converting uncommon STRING to TIMESTAMP
- BigQuery UDF: How to sum(case when)
- Bigquery export data output is not in proper order
- Persistent UDF Issue in BigQuery
- Best Practices for Translating Hive UDF Java Logic to BigQuery SQL
- Levenshtein distance for words from list in Bigquery
- Convert the normal value to a IBM "packed decimal"
- BigQuery table functions with tables as arguments or return values
- BigQuery UDF Error: Correlated Subquery in Temp Function
- where to get tutorial to create a Big Query Project?
- BigQuery SQL Query Issue in PostMan
- Merge multiple instances of event_params from bigquery api
Related Questions in SPRING-CLOUD-GCP-BIGQUERY
- Bigquery, converting uncommon STRING to TIMESTAMP
- where to get tutorial to create a Big Query Project?
- GCP Billing Data Bigquery
- BigQuery Requests never returns
- CSV Export from Bigquery having columns surrounded with double quotes adding not working
- Spring boot integration with bigquery
- Why am I unable to use a timezone converted column to filter a day partitioned table?
- Problem importing google-cloud-bigquerystorage maven dependency
- Trouble connecting to BigQuery using Google Cloud Client Library in a Spring Boot Application
- which is the best way to query GCP usage cost from BigQuery in java?
- Array_agg not allowed within UNNEST in bigquery | Google Bigquery
- Value of type ARRAY<STRUCT<value ARRAY<STRING>>> cannot be assigned to M.preferences_testing, which has type STRING
- BigQuery - How to instantiate BigQueryTemplate without env variables? getting The Application Default Credentials are not available
- BigQuery : Bulk update Table using DML queries
- How to get paginated data from BigQuery in Java?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
i was able to resolve using this query CONCAT(SPLIT(SPLIT(datetime_cols, ' ')[0],'/')[0], '-' ,LPAD(SPLIT(SPLIT(datetime_cols, ' ')[0],'/')[1], 2, '0'), '-', LPAD(SPLIT(SPLIT(datetime_cols, ' ')[0],'/')[2], 2, '0'),' ', LPAD(SPLIT(SPLIT(datetime_cols, ' ')[1],':')[0], 2, '0'),':',LPAD(SPLIT(SPLIT(datetime_cols, ' ')[1],':')[1], 2, '0'),':',LPAD(SPLIT(SPLIT(datetime_cols, ' ')[1],':')[2], 2, '0'))