Tagged Questions
2
votes
1answer
101 views
Setting DATEFIRST to 6
I would like to set FIRSTDATE to 6 (ie: saturday), i have read that to change it parmanently i could set the default language of the login to one of an existing language from the sys.syslanguages and ...
0
votes
1answer
49 views
UTC date in DMV dm_broker_queue_monitors
It seems that the DMV dm_broker_queue_monitors returns UTC time rather than local time. Why is it so?
I am wondering how to get local time from this view? I can get current time offset, but that is ...
0
votes
2answers
174 views
Convert datetime to europe default without time
I have a datetime field that I need to convert into the format DDMONYY (27Aug12). I am currently using convert(nvarchar(30),DateToConvert,13), but that also spits out the time. How can I easily ...
2
votes
3answers
427 views
SQL Server dates - can I get date and hour?
In SQL Server, can I do the equivalent of to_char(date_field, 'YYYY-MM-DD:HH24') in Oracle to get 2012-01-30:23?
8
votes
3answers
1k views
Storing date as integer (numeric), what are the advantages
Question 1
I am working with a system where date is stored as integer (actual numeric(8,0)) and I have noticed that other systems also store date as int such as cisco in this thread. Example
...
