I agree. It seems unfortunate, but remember that SQL is just plain text being sent to the database engine. Access etc do something similar. Some databases provide functions, e.g. Oracle's TO_DATE, but they are usually either limited or perform poorly. Construct the text string yourself in code. Glen -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Sunday, 16 July 2006 2:08 PM To: [email protected] Subject: Re: [delphi-en] Delphi SQL Date format change
Hi, I think, the date format in SQL is not changable. it is always MM/DD/YYYY. Have fun Bob > Thanks a lot for your help > > > Hi all who can help me please?In query of Delphi the default date format is > > MM/DD/YY and when I want to search by date I have to > > put MM/DD/YY, how can I change the format,that the > > user can search it like DD/MM/YY? > > > > My Db is paradox signing with BDE (I have changed the BDE date config > > but no changes) > > > > Please help me with this if someone can. > > > > Thank You a lot > > > > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Great things are happening at Yahoo! Groups. See the new email design. http://us.click.yahoo.com/TISQkA/hOaOAA/yQLSAA/i7folB/TM --------------------------------------------------------------------~-> ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
