DOCUMENTATION
/
Get started
Guides
Developer
Reference
Release notes
Tutorials
Status
  1. Overview
    • Snowflake Horizon Catalog
    • Applications and tools for connecting to Snowflake
    • Virtual warehouses
    • Databases, Tables, & Views
    • Data types
      • Data Integration
        1. Snowflake Openflow
        2. Apache Iceberg™
          1. Apache Iceberg™ Tables
          2. Snowflake Open Catalog
      • Data Engineering
        1. Data Loading
        2. Dynamic Tables
        3. Streams and Tasks
        4. dbt Projects on Snowflake
        5. Data Unloading
      • Storage Lifecycle Policies
      • Migrations
      • Queries
      • Listings
      • Collaboration
      • Snowflake AI & ML
      • Alerts & Notifications
      • Security
      • Data Governance
      • Privacy
      • Organizations & Accounts
      • Business continuity & data recovery
      • Performance optimization
      • Cost & Billing

      snowflake.snowpark.functions.to_time¶

      snowflake.snowpark.functions.to_time(e: Union[Column, str], fmt: Optional[Column] = None) → Column[source]¶

      Converts an input expression into the corresponding time.

      Example:

      >>> df = session.create_dataframe(['04:15:29.999'], schema=['a'])
      >>> df.select(to_time(col("a"))).collect()
      [Row(TO_TIME("A")=datetime.time(4, 15, 29, 999000))]
      
      Copy

      Was this page helpful?

      Visit Snowflake
      Join the conversation
      Develop with Snowflake
      Share your feedback
      Read the latest on our blog
      Get your own certification
      Privacy NoticeSite TermsCookies Settings© 2025 Snowflake, Inc. All Rights Reserved.
      Language: English
      • English
      • Français
      • Deutsch
      • 日本語
      • 한국어
      • Português