. We've got lots of great SQL Server experts to answer whatever question you can come up with. All Forums General SQL Server Forums New to SQL Server Programming Minus hour from a Date
How to retrive DAY name from Date in SSRS 2008 R2 How to round off 14.5 to 15 in SSRS How to run a Query at 12AM and 12PM How to run Batch file from ssms How to run the ssrs reports automatically at a specified time ? How to save report in text (.txt) format using SSRS How...
Days: SQL> SELECT TO_CHAR(SYSDATE -1, 'dd-mm-yy hh24:mi:ss') from dual; Hours: SQL> SELECT TO_CHAR(SYSDATE-(1/24), 'dd-mm-yy hh24:mi:ss') from dual; Minutes: SQL> SELECT TO_CHAR(SYSDATE-1/(24*60), 'dd-mm-yy hh24:mi:ss') from dual; ...
I would expect people with reasonable experience in SQL Server to know what 0 is, it's the default "base date" in SQL Server. If not, they can quickly Google it and get an accurate answer, and why it's used. For -1, no. Also, as noted before, -1 has caused errors because of...
I am having a few locking issues, i have an SSIS package that crashed whilst in operation. the package simply truncates and reload data from one db to another. The package crashed with the "visual studio is busy trying to complete an internal operation" error message. as the package becam...
SELECT CONVERT(DATETIME,CONVERT(VARCHAR,'2006-03-01',121) + ' 11:25:25.526 ',121) I have add the time part to a date field which i have taken first, as a varchar and then add the time part into it and thereafter convert it into a datetime data type. ...
And why LocalDateTime - in most cases the time zone of the field will be known, even if it's not actually stored (ie, the convention to store date/time as UTC) Correct, we assume that all database times are in UTC. As such, we wanted to avoid any sort of timezone conversions rela...
How to avoid default date in DateTime class in c#? How to avoid flickering in Main Form while try to hide and show the child forms how to avoid graphic flickering in picture box in C# How to bring my form to front How to build release version of a win forms project? How to calc...
How to retrive DAY name from Date in SSRS 2008 R2 How to round off 14.5 to 15 in SSRS How to run a Query at 12AM and 12PM How to run Batch file from ssms How to run the ssrs reports automatically at a specified time ? How to save report in text (.txt) format using SSRS...
Filtering to return date field > today minus 5 days? (report builder 3.0) Find if value exists in Dataset find stored procedure name for ssrs reports Find the difference between two columns in an ssrs matrix ? MSCRM Finding a valid SQL Server Product Key on Azure VM First day of last...