Jul
10
comment SQL Server 2008/2012: How to convert UTC time to local time given as a .NET timezone name?
Because we aren't able to customise the presentation layer. In order to implement a report, we just write SQL. The system does some processing of the output - to add a filtering interface and suppress repeated values in some fields - but it doesn't do time zone conversion or even date/time formatting (so we already have to do this in the SQL, and so all the system receives to render is a string).
Jul
10
comment SQL Server 2008/2012: How to convert UTC time to local time given as a .NET timezone name?
I've had a quick look at DateTimeOffset already. But I can't see how it can help me with what I'm trying to do.
Jul
10
revised SQL Server 2008/2012: How to convert UTC time to local time given as a .NET timezone name?
clarify something else we can't do
Jul
10
asked SQL Server 2008/2012: How to convert UTC time to local time given as a .NET timezone name?
May
19
answered How to set date format in HTML date input tag?
May
18
comment How to calculate age (in years) based on Date of Birth and getDate()
Why 365.23076923074? It isn't the mean length of a year in any calendar I'm familiar with.
Apr
28
comment SecureBlackBox - does TElSimpleSFTPClient.UploadStream automatically create folders if they don't exist? How to suppress?
I'm surprised about this. If I try to save a file in a typical application, it will complain if the folder I try to save into doesn't exist, rather than silently creating the folder. I haven't experimented with this aspect of different file I/O APIs but have always imagined them to be the same. Still, I'm curious about whether the library does extra work to check whether the folder exists before attempting the upload, as opposed to (for example) attempting the upload and then creating the folder and trying again if it fails. Anyhow, thanks for the enlightenment!
Apr
27
asked SecureBlackBox - does TElSimpleSFTPClient.UploadStream automatically create folders if they don't exist? How to suppress?
Apr
24
awarded Supporter
Apr
24
comment How to restore a previous version of file in Notepad++
Thanks a lot! You saved my life!
Apr
24
asked SQL Server - any equivalent of Excel's CHOOSE function?
Apr
17
awarded Caucus
Apr
1
awarded Yearling
Apr
1
awarded Yearling
Mar
27
comment Is it good practice to "force" users to update their browser?
Maybe the CSS file itself could be done using server-side scripting. The browser would cache whichever version gets loaded, thereby greatly reducing the server load compared to having server-side scripting on each page. But I agree that it shouldn't be necessary.
Mar
25
comment c# First monthletter in uppercase
"If a date occurs at the beginning of a sentence, it isn't date formatting." How do you work that out?
Mar
16
revised What is the adjective meaning "great in area"?
rephrase to clarify
Mar
15
asked What is the adjective meaning "great in area"?
Mar
11
comment Prolog: My newly created list becomes empty on exiting recursion?
It isn't clear what you're trying to do. Could you please give a brief description of the problem you're trying to solve and the algorithm you're trying to implement? Moreover, I have noticed that ReturnList is not referenced in the definition of df_real. Am I right in thinking you want to build up the list in here?
Mar
5
comment Efficient way to read big endian data in C#
Yes, I've used something like this for some of my projects (albeit not in C#). But I had expected BinaryReader/Writer to have endian control built in, which would make it much simpler.
1 2 3 4 5