|
Just a quick SQL question. I found lots of way to convert numeric to real dates, but nothing for date to numeric on searching the archives. Here is what I did: YYMMDD = MOD(YEAR(ISODATE),100)*10000+MONTH(ISODATE)*100+DAY(ISODATE) I also had some "0001-01-01" to zero handling. It worked okay, but I didn't have many records, and it was ugly to read. Is there a more efficient/cleaner method for doing this? I know I could build a UDF, but for one I've never done so, and for another that might rock the "shop standards" boat a bit, which isn't necessarily worth it yet for the amount of pure SQL that we use. TIA, Adam ##################################################################################### Attention: The above message and/or attachment(s) is private and confidential and is intended only for the people for which it is addressed. If you are not named in the address fields, ignore the contents and delete all the material. Thank you. Have a nice day. For more information on email virus scanning, security and content management, please contact administrator@xxxxxxxxxxxx #####################################################################################
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.