323 reputation
511
bio website google.com/profiles/…
location Malaysia
age 29
visits member for 3 years, 6 months
seen Jul 23 at 10:52

You know where to read more about me. :)


Nov
8
awarded  Commentator
Jun
13
comment How to Handle TimeZone Properly in SQL SERVER?
Seems like your question is not just about database itself, but involves application development too. This Stack Overflow question is a must-read for you then: Daylight saving time and Timezone best practices
Jun
13
comment How to Handle TimeZone Properly in SQL SERVER?
Yes, agree with your comment on controlling the data input. In your answer above, you were talking about storing datetime values. Generally, datetime values would be stored based on a chosen offset (i.e. 0), so there is no need to store the datetime values with offset, unless there is some kind of special requirements to know the origin local time, which is not often necessary.
Jun
10
comment How to Handle TimeZone Properly in SQL SERVER?
Why is using the latter method (b) playing with fire? Could you explain more on that?
May
21
awarded  Constituent
May
21
awarded  Caucus
Jan
4
awarded  Yearling
Nov
25
awarded  Taxonomist
Sep
20
awarded  Nice Answer
Feb
15
awarded  Enthusiast
Jan
20
awarded  Scholar
Jan
20
accepted How to get the Oracle Text Index's underlying Virtual XML Document?
Jan
10
awarded  Beta
Jan
7
answered Where are some useful SQL puzzles to teach SQL in a workplace?
Jan
7
revised What can I do to find out since which release a given DBMS supports a feature, function, etc?
Add in more idea.
Jan
7
answered What can I do to find out since which release a given DBMS supports a feature, function, etc?
Jan
7
comment How to get the Oracle Text Index's underlying Virtual XML Document?
@Brian, oh thanks, I was looking at Oracle 10g Release 1 actually.
Jan
7
comment How to get the Oracle Text Index's underlying Virtual XML Document?
@Brian, the SNIPPET function is for Oracle 11g, is it? I'm working on [oracle-10g] here, but thanks for the info by the way. :)
Jan
7
awarded  Student
Jan
7
comment How to get the Oracle Text Index's underlying Virtual XML Document?
@Brian, done :)