Convert date into mm dd yy format sql

Top sites by search query "convert date into mm dd yy format sql"

  http://datawarehouse.ittoolbox.com/groups/technical-functional/informatica-l/how-can-i-convert-the-date-format-in-informix-from-mmddyy-to-yymmdd-2540481
No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters

  http://forums.iprodeveloper.com/forums/aft/66401
Makes me wonder even more if you can just call procedures using UDF's so you don't really have to code any odd SQL UDF's other than the call to the procedure. Having been frustated so many times by SQL converting into and out of Dates, I finally bit the bullet and created myself a Calendar File so that now I just Join to it via a Date in one format and use the corresponding Column in the required format

  http://www.tek-tips.com/viewthread.cfm?qid=1652912
Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... Your date is stored as the number of days since 1900-01-01, so all you need to do is add the number of days between 0001-01-01 and 1900-01-01 and convert it into a date format.Normally here at tek tips, we would leave it at that and let you work out the SQL yourself as there is a great satisfaction in working these things out if given a hint.As you are extremely new to DB2, you might appreciate the code as it is little complex

  http://dba.stackexchange.com/questions/73091/converting-a-varchar-date-into-a-date-dd-mm-yy
(And, of course, I agree with the comments that dates should be stored in DATE data types in the database.) Reviewing the MSDN CONVERT documentation does not show a built-in conversion for your string, but it is easy to work around