This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more
SALES: 1-800-867-1380
MY ACCOUNT
PORTAL
Sign in
  • Features
    • Features
      • Infrastructure
      • Web
      • Mobile
      • Dev & Test
      • Media
      • Integration
      • Big Data
      • Big Compute
      • Data Management
      • Identity & Access Management
      • Storage, Backup & Recovery
    • Discover
      • What is Azure
      • Enterprise IT
      • Application Hosting
      • Azure vs. Amazon Web Services
      • Azure in China
    • Services
      COMPUTE
      • Virtual Machines
      • Web Sites
      • Mobile Services
      • Cloud Services
      DATA SERVICES
      • Storage
      • SQL Database
      • HDInsight
      • Cache
      • Backup
      • Recovery Manager
      APP SERVICES
      • Media Services
      • Services Bus
      • Notification Hubs
      • Scheduler
      • BizTalk Services
      • Visual Studio Online
      • Active Directory
      • Multi-Factor Authentication
      • Automation
      • CDN
      NETWORK SERVICES
      • ExpressRoute
      • Virtual Network
      • Traffic Manager
    • Case Studies
  • Pricing
    • Overview
    • Pricing Details
      COMPUTE
      • Virtual Machines
      • Web Sites
      • Mobile Services
      • Cloud Services
      DATA SERVICES
      • Storage
      • SQL Database
      • HDInsight
      • Cache
      • Backup
      • Site Recovery
      APP SERVICES
      • Media Services
      • Service Bus
      • Notification Hubs
      • Scheduler
      • Automation
      • BizTalk Services
      • Visual Studio Online
      • Active Directory
      • Multi-Factor Authentication
      • CDN
      NETWORK SERVICES
      • ExpressRoute
      • Virtual Network
      • Traffic Manager
      • Data Transfers
    • Calculator
    • Purchase Options
    • Member Offers
      • MSDN
      • BizSpark Startups
      • Microsoft Partner Network
    • Regions
    • Support Plans
    • FAQ
  • Documentation
  • Downloads
  • Add-ons
  • Community
    • Blog
    • Service Updates
    • Events
    • Partners
    • Education
    • Newsletter
  • Support
    • Support Options
    • Support Plans
    • Forums
    • Service Dashboard
    • Trust Center
      • Overview
      • Security
      • Privacy
      • Compliance
    • Legal
    • FAQ
FREE TRIAL
Azure Reference Stream Analytics Query Language Built-in Functions
Built-in Functions Date and Time Functions
Date and Time Functions
Date and Time Functions
Aggregate Functions
Analytic Functions
Array Functions
Conversion Functions
Date and Time Functions
DATEADD
DATEDIFF
DATENAME
DATEPART
DATETIMEFROMPARTS
DAY
MONTH
YEAR
GeoSpatial Functions
Input Metadata Functions
Mathematical Functions
Record Functions
String Functions
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.
This documentation is archived and is not being maintained.

Date and Time Functions (Azure Stream Analytics)

 

Updated: April 22, 2016

Applies To: Azure

Stream Analytics Query Language provides the following date and time functions:

DATENAME (Azure Stream Analytics)DATEPART (Azure Stream Analytics)DAY (Azure Stream Analytics)
MONTH (Azure Stream Analytics)YEAR (Azure Stream Analytics)DATETIMEFROMPARTS (Azure Stream Analytics)
DATEDIFF (Azure Stream Analytics)DATEADD (Azure Stream Analytics)

See Also

Built-in Functions (Azure Stream Analytics)
Aggregate Functions (Azure Stream Analytics)
Analytic Functions (Azure Stream Analytics)
Array Functions (Stream Analytics)
Conversion Functions (Azure Stream Analytics)
Record Functions (Azure Stream Analytics)
String Functions (Azure Stream Analytics)

Show:
Print Export (0)
Print Share
IN THIS ARTICLE
    Is this page helpful?
    Additional feedback?
    1500 characters remaining
    Thank you! We appreciate your feedback.
    Go Social
    • Facebook
    • Twitter
    • Rss
    • Newsletter
    • Microsoft Azure
    • Features
    • Services
    • Regions
    • Case Studies
    • Pricing
    • Calculator
    • Documentation
    • Downloads
    • Marketplace
    • Microsoft Azure in China
    • Community
    • Blogs
    • Forums
    • Events
    • Support
    • Forums
    • Service Dashboard
    • Support
    • Account
    • Subscriptions
    • Profile
    • Preview Features
    • Management Portal
    • Trust Center
    • Security
    • Privacy
    • Compliance
    Hello from Seattle
    English
    English Dansk Deutsch Español
    Français Italiano Nederlands Polski
    Português Svenska Türkçe Pусский
    日本語 한국어 简体中文 繁體中文
     
    • Contact Us
    • Trademarks
    • Privacy & Cookies
    • Feedback
    © 2017 Microsoft
    © 2017 Microsoft