SQL Query
[257 byte] By [yan_er04] at [2007-9-26 22:31:08] 
I have this sql query which is working in ASP, MS SQL now i am using JSP, MySQL but it is not working. Can anyone tell me why?The date_particular.date is store as a varchar.ORDER BY convert(datetime,date_particular.date,103) ASC
you can type this SQL in mysql tomake sure that mySQL has a convert() function,
warmcat at 2007-7-4 2:30:56 >
If MySQL does not have that function, how can i convert a char field to date?
yan_er04 at 2007-7-4 2:30:56 >
Enterprise & Remote Computing New Topic
Enterprise & Remote Computing Hot Topic
- connection problem to a sybase/mysql database in a linux server from win200
- J2EE start error
- Extracting elements from an xml string - org.apache.xerces.dom.DeferredText
- trim()
- JSP and Bean
- JOptionPane Problem
- Connecting to Database using the useBean tag and scope set to session
- Read data from text files and insert in to DB using XML?
Enterprise & Remote Computing
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding