![]() The data type of published_date column has been converted to the DATE type.Įxample #4: How to Use a CAST Operator to Convert a String Into a Double Type? Let’s convert it into DATE type using the CAST operator: SELECT CAST(published_date AS DATE) FROM article_details The published_date column has a text data type. Let’s execute the SELECT query to get the table’s details: SELECT * FROM article_details We have created a table named article_details in our database. The output shows that the data type of team_rating column has been changed to INTEGER data type.Įxample #3: How to Use CAST Operator For String to Date Type Conversion? Let’s convert it into INTEGER data type using the CAST operator: SELECT CAST(team_rating AS INTEGER) The result set shows that the team_rating column has a TEXT data type. Let’s run the SELECT statement to get the table’s details: SELECT * FROM team_details We have created a table named team_details. The output proves that the CAST operator takes a constant string and converts it into the desired data type, i.e., integer.Įxample #2: How to Use the CAST Operator to Table’s Column? ![]() ![]() Run the below statement to convert the given constant string to an integer: SELECT CAST ('572' AS INTEGER) ![]() The given expression will be converted into the targeted data type.Įxample #1: How to Use CAST Operator to Convert/Cast a String to Integer? While data_type represents a targeted data type. Here, exp represents an expression to be evaluated, such as a table’s column, an expression, or a constant. The below snippet illustrates the basic syntax of the CAST operator: CAST (exp AS data_type) How to Use the CAST Operator in PostgreSQL? Using practical examples, this post will explain how the CAST operator works in PostgreSQL. For this purpose, PostgreSQL provides a CAST operator that assists us in converting one data type to another. For instance, converting a numeric string into an int, a string to date, etc. In Postgresql, to cast or convert from int to float, pass the first value as an integer and second value data type that is float.While working with PostgreSQL, we may encounter a situation where we need to convert one data type into another. Read: Postgresql date_trunc function PostgreSQL cast int to float
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |