Class LegacySQLTypeName (2.34.2) 
  
      
     
  
  
  
   
  
    
  
  
    
    
    
  Version 2.34.2keyboard_arrow_down  
  
 
    
    
    
    
      
  
  
  
    
public   final   class  LegacySQLTypeName   extends   StringEnumValue  
   
  A type used in legacy SQL contexts. NOTE: some contexts use a mix of types; for example, for
 queries that use standard SQL, the return types are the legacy SQL types.
See Also: https://cloud.google.com/bigquery/data-types 
 
  
    Inheritance 
    java.lang.Object    >  
    com.google.cloud.StringEnumValue    >  
    LegacySQLTypeName 
   
  
    Inherited Members 
    
      com.google.cloud.StringEnumValue.equals(java.lang.Object) 
    
    
      com.google.cloud.StringEnumValue.hashCode() 
    
    
      com.google.cloud.StringEnumValue.name() 
    
    
      com.google.cloud.StringEnumValue.toString() 
    
    
    
    
    
    
    
    
    
   
  Static Fields
   
  BIGNUMERIC 
  
    
public   static   final   LegacySQLTypeName   BIGNUMERIC  
   
  A decimal value with 76+ digits of precision (the 77th digit is partial) and 38 digits of scale
 
  
  BOOLEAN 
  
    
public   static   final   LegacySQLTypeName   BOOLEAN  
   
  A Boolean value (true or false).
 
  
  BYTES 
  
    
public   static   final   LegacySQLTypeName   BYTES  
   
  Variable-length binary data.
 
  
  DATE 
  
    
public   static   final   LegacySQLTypeName   DATE  
   
  Represents a logical calendar date. Note, support for this type is limited in legacy SQL.
 
  
  DATETIME 
  
    
public   static   final   LegacySQLTypeName   DATETIME  
   
  Represents a year, month, day, hour, minute, second, and subsecond (microsecond precision).
 Note, support for this type is limited in legacy SQL.
 
  
  FLOAT 
  
    
public   static   final   LegacySQLTypeName   FLOAT  
   
  A 64-bit IEEE binary floating-point value.
 
  
  GEOGRAPHY 
  
    
public   static   final   LegacySQLTypeName   GEOGRAPHY  
   
  Represents a set of geographic points, represented as a Well Known Text (WKT) string.
 
  
  INTEGER 
  
    
public   static   final   LegacySQLTypeName   INTEGER  
   
  A 64-bit signed integer value.
 
  
  INTERVAL 
  
    
public   static   final   LegacySQLTypeName   INTERVAL  
   
  Represents duration or amount of time.
 
  
  JSON 
  
    
public   static   final   LegacySQLTypeName   JSON  
   
  
  
  NUMERIC 
  
    
public   static   final   LegacySQLTypeName   NUMERIC  
   
  A decimal value with 38 digits of precision and 9 digits of scale. Note, support for this type
 is limited in legacy SQL.
 
  
  RECORD 
  
    
public   static   final   LegacySQLTypeName   RECORD  
   
  A record type with a nested schema.
 
  
  STRING 
  
    
public   static   final   LegacySQLTypeName   STRING  
   
  Variable-length character (Unicode) data.
 
  
  TIME 
  
    
public   static   final   LegacySQLTypeName   TIME  
   
  Represents a time, independent of a specific date, to microsecond precision. Note, support for
 this type is limited in legacy SQL.
 
  
  TIMESTAMP 
  
    
public   static   final   LegacySQLTypeName   TIMESTAMP  
   
  Represents an absolute point in time, with microsecond precision.
 
  
  Static Methods
   
   
  legacySQLTypeName(StandardSQLTypeName type) 
  
    
public   static   LegacySQLTypeName   legacySQLTypeName ( StandardSQLTypeName   type )  
   
  Converts StandardSQLTypeName to LegacySQLTypeName
 
  
  
   
  valueOf(String constant) 
  
    
public   static   LegacySQLTypeName   valueOf ( String   constant )  
   
  Get the LegacySQLTypeName for the given String constant, and allow unrecognized values.
 
  
    
      
        Parameter  
       
      
        Name  
        Description  
       
      
        constant 
        String  
       
     
  
  
   
  valueOfStrict(String constant) 
  
    
public   static   LegacySQLTypeName   valueOfStrict ( String   constant )  
   
  Get the LegacySQLTypeName for the given String constant, and throw an exception if the constant
 is not recognized.
 
  
    
      
        Parameter  
       
      
        Name  
        Description  
       
      
        constant 
        String  
       
     
  
  
   
  values() 
  
    
public   static   LegacySQLTypeName []   values ()  
   
  Return the known values for LegacySQLTypeName.
 
  
  Methods
   
   
  getStandardType() 
  
    
public   StandardSQLTypeName   getStandardType ()  
   
  Provides the standard SQL type name equivalent to this type name.
 
  
 
     
    
  
  
  
     
  
 
  
    
    
      
       
    
    
  
  
 
  Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License . For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates.
  Last updated 2025-10-30 UTC.
 
 
  
  
  
    
      [[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-10-30 UTC."],[],[]]