SQL Query to pull Datetime columns and get the minimum data in each column and date coulmns

Question

Tulluri, Swathi 0

I wanted to write down the min(date columns) from all the data bases and all the tables which has datetime column.

The yellow column needs to be published in

I have writtent a query which could retrieve the data only to the perticular data base, i am lookiing to get it via dynamic SQL

What i could get

Jeff McCashland 481 Reputation points Microsoft Employee Moderator

2023-11-21T15:35:55.2033333+00:00

The Open Specifications tags are dedicated to supporting issues related to open specifications. You can find open specifications here https://docs.microsoft.com/en-us/openspecs/. Since your question does not pertain to one of these specifications, I've removed the openspecs tag.

1 answer

Jeff McCashland 481 Reputation points Microsoft Employee Moderator

2023-11-21T15:35:55.2033333+00:00

The Open Specifications tags are dedicated to supporting issues related to open specifications. You can find open specifications here https://docs.microsoft.com/en-us/openspecs/. Since your question does not pertain to one of these specifications, I've removed the openspecs tag.

Answer 1

Anonymous

You can refer to this post.

Best regards,

Percy Tang