jenniferG Posted July 20, 2007 Share Posted July 20, 2007 we have a table of type DATE and want to enter data into it where we have a date in the form of a string with month,date,year and year being four digits and we want to convert that to a msql date that is sortable when we INSERT rows. Thanks, Natalie Quote Link to comment Share on other sites More sharing options...
Barand Posted July 20, 2007 Share Posted July 20, 2007 Write the dates to the db table DATE col as 'yyyy-mm-dd' strings Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.