Convert Text(Date in ISO 8601 format) to DateTime

Home > database > Convert Text(Date in ISO 8601 format) to DateTime - Data Studio

Convert Text(Date in ISO 8601 format) to DateTime - Data Studio

Time：01-25

I need to convert a text that is in ISO 8601 Date format, to DateTime in DataStudio. When the text comes with the hour and timezone parts having non-zero values, it works normally.

Code to convert: DATETIME_ADD(PARSE_DATETIME("%FT%R:


          
          
            Page link：https//www.codepudding.com/database/682392.html
          
          
               Prev:API calls "FIFO" with .NET Core
               Next:Removing utc info from yfinance dataframe


  
    
      
        
          
             Tags：  
datetimeconvertersgoogle-data-studioiso8601               
        
      
    
  
 
    
      
        
        	
            	Related
            
                       
        
      
    
  

  
    
      
        
           Links：  
          CodePudding

            
      
    
  


  About Us:          Contact Us      Terms of Service      
Privacy Policy
  Copyright © 2010-2023，Powered By CodePudding