2 Questions in regards to a SQL Script.
I created the following Script in MSSQL and it is working.
SELECT
Change_fields
.
UDF_CHAR1
,
ltrim
(
dateadd
(
s
,
datediff
(
s
,
GETUTCDATE
()
,
getdate
())
+
(
CREATEDTIME
/
1000
),
'1970-01-01 00:00:00'
))
'Open Date'
,
changedetails
.
CHANGEID
,
INITIATORID
,
TECHNICIANID
,
STAGEID
,
PRIORITYID
,
CATEGORYID
,
SUBCATEGORYID
,
ITEMID
,
APPR_STATUSID
,
CHANGETYPEID
,
URGENCYID
,
TITLE
,
DESCRIPTION
,
SCHEDULEDSTARTTIME
,
SCHEDULEDENDTIME
,
COMPLETEDTIME
,
NOTESPRESENT
,
SITEID
FROM
ChangeDetails
,
Change_Fields
where
ChangeDetails
.
CHANGEID
=
Change_Fields
.
changeid
I'll get a return date for
,
ltrim
(
dateadd
(
s
,
datediff
(
s
,
GETUTCDATE
()
,
getdate
())
+
(
CREATEDTIME
/
1000
),
'1970-01-01 00:00:00'
))
'Open Date'
that reads
Mar 1 2012 3:06PM
First Question Is there a way I can trim the time off compeltely and only show the date?
Second Question I need an additional report similar to this one but rather than showing date I need to show Quarter (Q1-Q2-Q3-Q4)
So the date ranger for Q1 is April 1 - June 30
Q2 is July 1st Sepetember 30
Q3 is October 1st - December 31st
Q4 is January 1st - March 31st.
Thanks