If I create a view today for a table that continuously keeps getting data, using date filtering from 1900 and 2100, for example, will that “copy” become truncated to the moment that I build the view or since it is being filtered to a very large date will it keep showing the current data to the users that can access
Tag: sqldatetime
Return first date and previous dates
There is a custid with 3 dates . I want to return first date and then its previous date . data should look like: custid first previous 11 2019-06-10 2019-06-15 11 2019-06-10 2019-07-…
Save datetime in sql table
How I can insert with a query a date like this? 2015-06-02T11:18:25.000 I have tried this: But I have returned: I tried also: but it is not working: The entire query is: What is wrong? Answer Try this: 126 relates to ISO8601, which is the format yyyy-mm-ddThh:mi:ss.mmm. This is the same format as the string ‘2015-06-02T11:18:25.000’. For more information, see