How to filter rows with datetime fields (looking for month)

dhu_rem...@mmm.com

unread,

Jan 9, 2004, 11:10:06 AM1/9/04

to

Evita I'm somewhat confused..

I just made an external datawindow with one field, mydatetimes of data
type datetime.

I populated it with a half dozen rows of varying months.

I set the filter to

month( date( mydatetimes )) = 4

and it limited the rows displayed to april datetimes.

I don't think the problem is what you think that it is.

e_chapa

unread,

Jan 9, 2004, 10:41:58 AM1/9/04

to

Hey Y"all:

I know it sounds simple but I haven't been able to find the
right combo of either PB9 and/or Oracle 9i functions to do
this. I have to give user the ability to see a list of
birthdays based on month they select. The data has the
dates in oracle datetime format.

I thought I could do a filter like
month(date(date_of_birth)) = whatever number but it doesn't
work. The date function I wanted to use is powerscript and
the date dw expression function 'Converts a string whose
value is a valid date to a value of data type date' I
looked at oracle's functions but don't see a function I
could use. Please someone tell me I'm missing something.

Thanks,

Evita

Jerry Siegel

unread,

Jan 9, 2004, 11:34:15 AM1/9/04

to

How about String (date_of_birth, 'mm') = '12'

<E Chapa> wrote in message news:3ffecdde.79...@sybase.com...

WS

unread,

Jan 9, 2004, 2:15:10 PM1/9/04

to

my fav FAQ
Use to_char(my_date_col,'dd-mon-yy') for all date mappings instead of plain
my_date_col to deal with datetime columns

<E Chapa> wrote in message news:3ffecdde.79...@sybase.com...

e_chapa

unread,

Jan 12, 2004, 2:25:30 PM1/12/04

to

Appreciate the help y'all..I'll give those a try. Sorry I
haven't hanging around lately. Our client has changed their
firewall so I can't get in via OE. OE is much easier to
look at stuff than using a browser. I've heard other
software I could use but I'm not allowed to install those.

Thanks

Evita

DT

unread,

Jan 12, 2004, 3:06:04 PM1/12/04

to

Can you use Mozilla ? It's email client is very similar to OE.

<E Chapa> wrote in message news:4002f6ce.32...@sybase.com...

Jim Smith

unread,

Jan 12, 2004, 4:03:33 PM1/12/04

to

Evita,

Have you tried:

month(date_of_birth) = 10

if date_of_birth is date/datetime column, the above should work. Goto the
datawindow painter and experment with the filter. The Month function is valid
for filters.

I hope this helps.

Jim

On 12 Jan 2004 12:06:04 -0800,
in sybase.public.powerbuilder.datawindow

Jim Smith
Duqusene Light Company
jrs...@duqlight.com

e_chapa

unread,

Jan 13, 2004, 8:31:13 AM1/13/04

to

Nope..Not part of the client's standard workstation
install...Thanks for the suggestion though :)

Evita

e_chapa

unread,

Jan 13, 2004, 8:35:02 AM1/13/04

to

Ah, got ya...I just need to look at to_date then to just
show the month and day..Thanks..

e_chapa

unread,

Jan 13, 2004, 8:40:11 AM1/13/04

to

Hey WS,

Long time no hear :)..Duhhh...Been writing docs and
testplans lately..Totally forgot about to_char..Ok, y'all
can shoot me now :P

Evita

e_chapa

unread,

Jan 13, 2004, 8:41:36 AM1/13/04

to

Hi,

I must've typed in something wrong..It works now..Thanks for
the help :)

Evita