Yandex Cloud
Search
Contact UsGet started
  • Blog
  • Pricing
  • Documentation
  • All Services
  • System Status
    • Featured
    • Infrastructure & Network
    • Data Platform
    • Containers
    • Developer tools
    • Serverless
    • Security
    • Monitoring & Resources
    • ML & AI
    • Business tools
  • All Solutions
    • By industry
    • By use case
    • Economics and Pricing
    • Security
    • Technical Support
    • Customer Stories
    • Cloud credits to scale your IT product
    • Gateway to Russia
    • Cloud for Startups
    • Education and Science
    • Yandex Cloud Partner program
  • Blog
  • Pricing
  • Documentation
© 2025 Direct Cursus Technology L.L.C.
Yandex DataLens
    • Overview
    • Formula syntax
      • All Functions
        • Overview
        • BOOL
        • DATE
        • DATETIME
        • DATETIME_PARSE
        • DATE_PARSE
        • DB_CAST
        • FLOAT
        • GEOPOINT
        • GEOPOLYGON
        • INT
        • STR
        • TREE
      • Function Availability
    • Parameters
  • Audit Trails events
  1. Calculated fields
  2. Function reference
  3. Type conversion functions
  4. STR

STR

Written by
Yandex Cloud
Improved by
amatol
Updated at November 6, 2024

SyntaxSyntax

STR( expression )

DescriptionDescription

Converts the expression expression to string type.

Argument types:

  • expression — Array of fractional numbers | Array of integers | Array of strings | Boolean | Date | Datetime | Fractional number | Geopoint | Geopolygon | Integer | String | UUID

Return type: String

Note

If an array is passed (only for ClickHouse, PostgreSQL sources), the conversion is performed by a function in the source database and results may vary for different data sources. For consistent results use ARR_STR.

ExamplesExamples

STR(77) = "77"
STR(1 != 1) = "False"
STR(#2019-01-01#) = "2019-01-01"
STR(ARRAY(1, 2, 3, NULL)) = {1,2,3,NULL}  PostgreSQL
STR(ARRAY(1, 2, 3, NULL)) = [1,2,3,NULL]  ClickHouse
STR(ARRAY('a', 'b', '', NULL)) = {a,b,,NULL}  PostgreSQL
STR(ARRAY('a', 'b', '', NULL)) = ['a','b','',NULL]  ClickHouse

Data source supportData source support

ClickHouse 21.8, Files, Google Sheets, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, Yandex Documents, YDB.

Was the article helpful?

Previous
INT
Next
TREE
© 2025 Direct Cursus Technology L.L.C.