SQL Server Forums - Today's Date in Select - GetDate()?
How can I get Convert to work with GetDate()? Or shouldn't I be using GetDate()?The Cast(GetDate() as VarChar(11)) is about as close as I got but that is the format I want. to include the Time portion when we need to.Sorry, Rabbiting on, but that's what I was referring to about having the Presentation layer do the formatting; if you do a convert to varchar(10) you have converted the date to text; if something wants to process that date, as a date, it has to be pretty sure that it knows what format it is formatted to - for now, and for ever in the future
In .NET applications, you can usually format dates in data bound controls using the GUI interface, and you can also format things using the ToString() method of a true datetime value and specify all kinds of simple yet flexible formatting strings. Isn't it much easier to simply right-click on something and then enter a simple "mmm dd, yyyy" format string instead of building and parsing this manually using CONVERT and SUBSTRING parsing in T-SQL? Isn't it more flexible to do all formatting at your presentation layer so that you can just return data from your database and not worry about how it looks? Then 5 different clients can query the same stored procedure and each output those dates any way they want -- without changing any database code
Querying SQL Server 2012: Part I - CodeProject
That would at least qualify for a LEFT OUTER JOIN, but there are also CurrencyRates that do not have orders, which would also qualify a join between the tables for a RIGHT OUTER JOIN. Since order is not guaranteed in SQL Server it would be logical to use an ORDER BY, but maybe you really do want to skip a few random rows after which you select a few other random rows
Querying SQL Server 2012: Part II - CodeProject
8.1 CROSS APPLY The CROSS APPLY operator works like an INNER JOIN in that it can match rows from two tables and leaves out rows that were not matched by the other table in the result. The following query gets the top three most expensive orders regardless of customer and as a result each Person is duplicated three times in the result (once for each order, regardless of whether the order was placed by this Person)
SQL Server Forums - Getting the date portion of a datetime value
You can also use DateAdd() to truncate the time portion like so:SELECT DateAdd(day, DateDiff(day, 0, dateCol), 0) FROM myTableHere, DateDiff counts the number of days since 0 (Jan. 1, 1900) and then DateAdd adds that number of days to zero, thus giving you the date at midnight (essentially, no time value).You can use DateAdd in this fashion to get any kind of date interval, weeks, months, years, etc
Best approach to remove time part of datetime in SQL Server - Stack Overflow
If using a UDF, it should be noted that you should try to avoid using the UDF as part of a WHERE clause in a query as this will greatly hinder performance of the query. Edit, Jan 2012 A worked example of how flexible this is: Need to calculate by rounded time or date figure in sql server Edit, May 2012 Do not use this in WHERE clauses and the like without thinking: adding a function or CAST to a column invalidates index usage
How to return the date part only from a SQL Server datetime datatype - Stack Overflow
Both queries have the same execution plan, but execution plans are primarly about data access strategies and do not always reveal implicit costs involved in the CPU time taken to perform all the pieces. Making such conversions in the data tier is a huge waste of overhead on your DBMS, but more importantly, the second you do something like this, you have basically created in-memory orphaned data that I assume you will then return to a program
Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account
Definately not if you're going to convert it back to a DateTime afterwards.It basically shows either a lack of knowledge, or complete disregard, for what is actually happening 'under the hood'. is there another option for formatting? BLOGERCISE Sep 1, 2009 at 11:03 AM 1 Comments Apologies if someone mentioned it, I'm not reading all the comments lol! But do you even need the floor?Select CAST(cast( GETDATE() AS INT ) AS DATETIME) Nic Sep 1, 2009 at 11:53 AM 10 Comments Converting to INT doesn't work in all cases as it will round up to the following day for timestamps after 12:00 noon
This is working fine but I also need to include in the result of the query days of the month where a transaction did NOT take place, those days should show as zero when counted.. The method he suggested was to use SELECT DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) I approved his method though, I finally suggested my method using function CONVERT
No comments:
Post a Comment