哪个日期比其他日期大? [英] Which date is Greater than other?

问题描述

亲爱的代码项目查看器

哪个日期比其他日期大?

我对日期和时间有疑问

示例:

Dear Code Project Viewer

Which date is Greater than other one?

I have Doubt for date and time

Example:

Date1 ="1/3/2012 8:30:00 AM" and Date2 = "1/3/2012 5:44:00 PM"

给我答案

通过mohan.

Give me answer

By mohan.

推荐答案

Date1 ="1/3/2012 8:30:00 AM"和Date2 ="1/3/2012 5:44:00 PM "


Date2大于date1

Date1 ="1/3/2012 8:30:00 AM" and Date2 = "1/3/2012 5:44:00 PM"


Date2 is greater than date1

很明显mohan Date2更大..

Hi,
It is quite obvious mohan Date2 is greater..

insert into Table (Date)
values ('2005-03-01 08:30:00 AM')

insert into Trans (Date)
values ('2012-03-01 05:44:00 PM')

SELECT MAX(Date) FROM Table

这篇关于哪个日期比其他日期大?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！