RichNetApps
Internet Applications - Flash, Flex, Silverlight, JavaFX
  • Home
  • About
  • Contact
  • All Downloads
  • Free Tools
    • Mini FLV Player
    • Mini MP3 Player
    • Flash Slideshow
    • Flash Pie Chart
  • Design and Photography
  • Services
  • Games
  • .NET
  • ColdFusion
  • CSS/Ajax
  • Flash
  • News
  • Oracle
  • PHP/MySQL
  • Reviews
  • Subscribe
Browse: Home / pl/sql

pl/sql

Get the Current Date for PL/SQL

Get the Current Date for PL/SQL

By Sanda Borlea on December 23, 2005

This is not really a post, just a small note on an item that can make you lose precious time hunting for…
To get the current date in a PL/SQL query in order to compare it with other fields or data from the Oracle database, do this:
select extract(year from sysdate)
from dual
This gets the current [...]

Posted in Oracle | Tagged Oracle, pl/sql, sql

Latest Articles

  • The (sad) state of web fonts embedding
  • WCF-LINQ Exception : Cycled Object Reference
  • flashCHESS III in Google Chrome OS
  • LINQ Demystified : Using LINQ on Existing Data Model
  • Add Custom VS Snippets
  • VirtueMart quick tip: show brand/manufacturer logo in product details
  • Flash exported as native apps on iPhone? Didn’t see that coming
  • Using MySQL to generate daily sales reports with filled gaps
  • Money for Nothing and Flex for Free
  • Javascript animated collapsible panels without any frameworks

Tag Cloud

.net actionscript adobe ajax c# chess code ColdFusion component css download effects filters flash flex flv free fusebox gallery google html iis issues javascript lightroom linq microsoft motion mssql mysql Oracle performance php piechart pl/sql raw reporting services smtp source sql store triggers tutorial xml xslt

Copyright ©2010 Media Division