convert string to date in mysql4.0.24

WeberForums.com Forum Index -> MySQL General

View previous topic :: View next topic   Author Message ramkumar Joined: 04 Jan 2008 Posts: 11 Posted: Thu Feb 07, 2008 7:12 am    Post subject: convert string to date in mysql4.0.24 Hi, I use mysql4.0.24. Date is stored as string('15/01/2008') in mysql table.Now i want to filter the records based on the date column using <,> and between operatoes.But i am unable to do it.How can i convert the date column from string data type to date data type and check it. I use cast() function.But it is not properly worked in mysql4.0.24.Please anyone tell me the query. Thanks in advance. Back to top lostboy Joined: 02 May 2004 Posts: 5128 Location: toronto, canada Posted: Thu Feb 07, 2008 5:25 pm    Post subject: use the CAST syntax _________________ Lostboy Cat, the other other white meat Please read Posting Etiquette before posting You can always try Google Back to top SkyM Joined: 31 Aug 2004 Posts: 24 Location: Oradea, Rou Posted: Thu Feb 07, 2008 7:23 pm    Post subject: Please post the query you used, perhaps it helps to see what you did wrong. _________________ "I don't believe in endings, I only believe in new beginnings" Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First

WeberTrivia Questions   Think you are smart? Prove it!. Try your skills with these questions :   Recursive arrays and multi-dimensional arrays are one and the same. (PHP and MySQL)   The \"cache_dir\" tag of the squid configuration has a default of /var/spool/squid. (Linux) PHP Code Examples   Stream diffrent sizes of images from a single image to save disk space.   JavaScript dropdown list menu to switch any page.   Dump the contents of a PHP variable in html format with a recursive list of subfolders and files from a given root directory.   PHP Dump in html format the contents of one array variable with a recursive list of the nested array variables inside.   Link Extractor - This function is used to extract links from a given URL. This will convert relative path into absolute path and also remove PHPSESSID stuff.   Building a Dynamic Form using Javascript and innerHTML. Add form elements in realtime without refreshing the page.   A PHP Calendar function with CSS : add a cool calendar to any php page by just adding a calendar class based function.

	WeberForums.com Forum Index -> MySQL General	All times are GMT + 2 Hours
Page 1 of 1

Jump to: Select a forum PHP Forums----------------PHP GeneralPHP MySQL Jobs and ProjectsPHP Articles Tutorials and ScriptsWhy Use PHPPEARPHP Books MySQL Forums----------------MySQL General Apache Forums----------------Apache General Web Development Forums----------------Java Script / AJAXSearch Engine Optimization (SEO)Cascading Style SheetsHTMLXML & XSL Graphics & Design----------------Theory related web designWeb Design Security Forums----------------Security Linux Forums----------------Linux General Web Development Misc----------------Hosting Related Miscellaneous----------------Feedback & TestimonialsMisc  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum