Home » SQL & PL/SQL » SQL & PL/SQL » calculate first date of any month
calculate first date of any month [message #410902] Wed, 01 July 2009 00:34 Go to next message
vivek_rol
Messages: 65
Registered: February 2009
Member
how to calculate first date of any month
is there any inbuild function?
Re: calculate first date of any month [message #410905 is a reply to message #410902] Wed, 01 July 2009 00:39 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The first date of any month is 1. Wink

TRUNC

Regards
Michel
Previous Topic: CREATE TABLE with LONG datatype, shows error
Next Topic: index on a huge table
Goto Forum:
  


Current Time: Sat Dec 10 14:31:49 CST 2016

Total time taken to generate the page: 0.15029 seconds