mysql varchar列中的最大日期 [英] Max of Dates in mysql varchar column

问题描述

嗨所有



我有一张表，其中我有一个varchar列，用于存储某些事件的日期。是使用mysql Query从该列获取最大和最小日期的任何方式。

它是一个非常古老的表，它包含很多记录，我不能修改架构，因为它也被使用在其他一些应用程序中。

日期以dd-MMM-yyyy格式存储

谢谢

hi all

i have a table in which i have a varchar column which stores date of some events. is ther any way to get the maximum and minimum dates from that column using mysql Query.
its a very old table and it contains so many records , i cant modify the schema and all since it is also used in some other applications.
dates are stored in dd-MMM-yyyy format
thank you

推荐答案

您可以使用SQL的IsDate功能来检查字符串是否采用正确的日期格式。



可以试试下面的查询吗？

Hi,

You can use "IsDate" function of SQL to check whether the string is in proper date format or not.

Can you please try with below query ?

SELECT MAX(T.DATE)
FROM (
    SELECT CASE
            WHEN ISDATE(YourDate) = 1
                THEN CAST(YourDate AS DATE)
            ELSE NULL
            END AS DATE
    FROM YourTable
    ) T

如果您对此有任何疑问或疑问，请与我们联系。



谢谢

Advay Pandya

Please let me know if you have any concern or query on this.

Thanks
Advay Pandya

这篇关于mysql varchar列中的最大日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！