Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > IBM DB2 > Date function i...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 8860 of 9056
 Post > Topic >>

Date function in DB2 V8.1 for Z/OS

by JAW <jwilliam@[EMAIL PROTECTED] > May 6, 2008 at 01:56 PM

I need to get the first day of the previous month in a query.

I thought CURRENT DATE and DAYOFMONTH would allow me to da it but it
is noe

WHERE DTXL >= 1st day of previous month


Anyone got a good idea?




 5 Posts in Topic:
Date function in DB2 V8.1 for Z/OS
 JAW <jwilliam@[EMAIL P  2008-05-06 13:56:04 
Re: Date function in DB2 V8.1 for Z/OS
 Lennart <Erik.Lennart.  2008-05-06 15:11:36 
Re: Date function in DB2 V8.1 for Z/OS
 "The Boss" <  2008-05-07 01:16:00 
Re: Date function in DB2 V8.1 for Z/OS
 Tonkuma <tonkuma@[EMAI  2008-05-06 16:21:54 
Re: Date function in DB2 V8.1 for Z/OS
 Tonkuma <tonkuma@[EMAI  2008-05-06 19:52:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup
Contact
tan13V112 Sun Jul 6 22:05:54 CDT 2008.