Search Date functions

From: Liming Xu <lmxu_at_glue.umd.edu>
Date: Mon, 25 Sep 2000 14:47:32 -0400
Message-ID: <39CF9DC4.3D67169B@glue.umd.edu>

hi, i'm haveing a little trouble converting a string in the format of "MM-DD-YYYY" to the corresponding version of "date" type..

I'm using Pro C...

here is what I have in the program

EXEC SQL declare curdob cursor for

                                select dob,name from Contacts where

todate(dob) like todate(:tdob) ORDER BY todate(dob),name; EXEC SQL open curdob;
EXEC SQL fetch curdob into :cmatchdob,:cmatchname;

Variable Descriptions:
dob: date column name in the table
name: name column in the table.
:tdob: the string date I read from the input...
:cmatchdob: a string to store date.....

Thanks. Received on Mon Sep 25 2000 - 13:47:32 CDT