DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Newsletter
Log In / Join
Refcards Trend Reports
Events Video Library
Refcards
Trend Reports

Events

View Events Video Library

Related

  • Grounding AI Agents in Governed Data
  • Engineering Self-Healing SQL Pipelines With LLMs: Validation, Guardrails, and Safe Recovery
  • RavenDB Launches Quill to Bring Production AI Agents to Enterprise SQL Systems, No Migration Required
  • Memory-First Indexes in SQL Server 2025: Redefining Performance for Hybrid Workloads

Trending

  • OpenAI ‘o’ Leak: What We Know About ChatGPT’s Always-On Assistant Before DevDay
  • Building an AI-Ready Data Layer Without Rebuilding the Enterprise
  • Embabel vs LangGraph4j: Two Agentic Philosophies for Investment and Risk Analysis in BFSI
  • Building High-Performance Time-Series Applications With Java and QuestDB
  1. DZone
  2. Data Engineering
  3. Databases
  4. Calcular A Idade Em SQL

Calcular A Idade Em SQL

By 
Erico Marineli user avatar
Erico Marineli
·
Sep. 13, 09 · Code Snippet
Likes (0)
Comment
Save
Tweet
Share
6.4K Views

Join the DZone community and get the full member experience.

Join For Free
Faz o cálculo da idade de uma pessoa utilizando sql oracle


Select Trunc ( (SYSDATE - to_date('14/07/1980','dd/mm/yyyy')) /365, 0 ) as "age" from Dual 
sql

Opinions expressed by DZone contributors are their own.

Related

  • Grounding AI Agents in Governed Data
  • Engineering Self-Healing SQL Pipelines With LLMs: Validation, Guardrails, and Safe Recovery
  • RavenDB Launches Quill to Bring Production AI Agents to Enterprise SQL Systems, No Migration Required
  • Memory-First Indexes in SQL Server 2025: Redefining Performance for Hybrid Workloads

Partner Resources

×

Comments

The likes didn't load as expected. Please refresh the page and try again.

  • RSS
  • X
  • Facebook

ABOUT US

  • About DZone
  • Support and feedback
  • Community research

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Core Program
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 3343 Perimeter Hill Drive
  • Suite 215
  • Nashville, TN 37211
  • [email protected]

Let's be friends:

  • RSS
  • X
  • Facebook