No announcements
Found 2007351 threads
-
0 Votesdatatype to datetype
in the following query, SELECT DEPARTMENT_DESCRIPTION, cast((lease_total_charge /((convert(int,convert(datetime,b.lease_end_date,112)) ...Answered | 1 Replies | 6427 Views | Created by cnsuman - Tuesday, September 29, 2009 6:39 AM | Last reply by Melissa Suciadi - Tuesday, September 29, 2009 7:03 AM
-
0 Votes
Problem ORDER BY by Nvarchar Datetype
@PageIndex - 1 * @MaximumRows AND RowNumberAnswered | 3 Replies | 4081 Views | Created by mohsendeveloper - Monday, May 31, 2010 1:03 PM | Last reply by Naomi N - Monday, May 31, 2010 2:16 PM -
1 Votes
Formula in Derived Column to replace the NULL for datetype
It works perfectly,thank you very much!!!Answered | 2 Replies | 2911 Views | Created by EliLeiz - Friday, February 24, 2012 8:30 PM | Last reply by EliLeiz - Saturday, February 25, 2012 7:39 AM -
0 Votes
Measure % not working as expected
This will work both from cube browser and EXCEL.Answered | 1 Replies | 766 Views | Created by AshokKOjha - Thursday, July 19, 2018 5:27 PM | Last reply by willson yuan - Friday, July 20, 2018 1:07 AM -
0 Votes
working with DateType
User1535942433 posted Hi binaarycode, Accroding to your description,I create a demo and it works fine,Do you have used Date in the database?Unanswered | 7 Replies | 104 Views | Created by Anonymous - Tuesday, May 19, 2020 10:05 AM | Last reply by Anonymous - Tuesday, May 19, 2020 3:54 PM -
0 Votes
DateType validation is not being displayed
Any reason why my DateType validation error is not being shown?Answered | 2 Replies | 43 Views | Created by Anonymous - Friday, October 24, 2014 6:45 AM | Last reply by Anonymous - Friday, October 24, 2014 7:28 AM -
0 Votes
SSMA Datetype mapping for DATE datatype of Oracle to SQL Server
In the SSMA project what I am observing is for mapping a column in Oracle with datatype DATE, the corresponding SQL Server datatype is given as DATETIME, DATETIME2, DATETIME2(Precision), ...Answered | 5 Replies | 1854 Views | Created by Phaneendra Babu Subnivis - Monday, October 28, 2019 9:07 AM | Last reply by Phaneendra Babu Subnivis - Monday, November 4, 2019 10:20 AM -
4 Votes
Nested Parameters
Define an enum with the names of all the different types of dates public enum DateType {Created, Expires, Cancelled, etc} Your Job class could have a ...Answered | 7 Replies | 740 Views | Created by GarrettHampton - Wednesday, May 22, 2013 12:30 AM | Last reply by Viorel_ - Wednesday, May 22, 2013 5:44 AM -
4 Votes
Why base class method could not pass the value back to derived class??
Your MapDateType method should be declared as protected virtual void MapDateType(ref dateType fieldToMap, DateTime ...Answered | 2 Replies | 3028 Views | Created by lax4u - Tuesday, April 19, 2011 8:56 PM | Last reply by Louis.fr - Wednesday, April 20, 2011 3:23 PM -
1 Votes
Need query to return data in separate rows in same row
Bring the field DateType for each table in the grid.Answered | 8 Replies | 5519 Views | Created by AllTheGoodNamesWereTaken - Monday, August 16, 2010 11:53 PM | Last reply by Mark Burns - PMADN - Tuesday, August 17, 2010 8:52 PM -
0 Votes
Datetype conversion
User-863835478 posted Let's consider the following segment of C# code: string []a = s.Split (delimiter); mID = a[0]; mName = a[1]; mDOB = a[2]; mSalary = a[3]; mPhoto = a[4]; ...Unanswered | 1 Replies | 38 Views | Created by Anonymous - Sunday, October 17, 2004 2:04 AM | Last reply by Anonymous - Sunday, October 17, 2004 6:11 AM -
4 Votes
get a holiday date for Memorial day every year from customized holiday table.
Your logic worked perfectly and I am able to get holiday dates for the year passed in.Answered | 18 Replies | 1881 Views | Created by Spunny - Wednesday, December 17, 2014 8:09 PM | Last reply by Satheesh Variath - Wednesday, January 14, 2015 9:14 AM -
0 Votes
How to read null DateType value and change it to some default string text
User1208776063 posted How to read null DateType value and change it to some default string text You can use ...Answered | 5 Replies | 239 Views | Created by Anonymous - Tuesday, April 22, 2014 2:15 PM | Last reply by Anonymous - Tuesday, April 22, 2014 9:35 PM -
0 Votes
The '' parameter is missing a value
The Report Parameters are: * Name: Date * (Visible) * Datetype: ...Answered | 2 Replies | 11795 Views | Created by optimus_86 - Tuesday, January 11, 2011 3:18 PM | Last reply by Tony Chain - Thursday, January 13, 2011 6:46 AM -
0 Votes
Help needed for datetime datetype
from test where varcharfield >= @startvarchar and varcharfieldAnswered | 6 Replies | 5222 Views | Created by samiksha - Wednesday, September 3, 2008 4:51 PM | Last reply by samiksha - Thursday, September 4, 2008 1:55 PM -
1 Votes
importing SQL 'date' type into pivot tables does not sort as date but as text
If I changed the data type from 'date' to 'datetype' in SQL, the pivot tables will sort correctly.Answered | 1 Replies | 3063 Views | Created by Radu Seserman - Wednesday, May 15, 2013 9:19 PM | Last reply by Brent Greenwood - Thursday, May 16, 2013 8:05 PM -
0 Votes
Nullable<DateType> in silverlight
I have a webservice in my silverlight project, that returns a List containing some data that the service extracts from a database. When i get the list in ...Answered | 1 Replies | 2243 Views | Created by MSDN_Forums_User - Thursday, July 24, 2008 5:35 AM | Last reply by MSDN_Forums_User - Thursday, July 24, 2008 7:12 AM -
0 Votes
Strange behaviour of "When item is created" trigger
But, I am glad it worked for you.Answered | 4 Replies | 438 Views | Created by RoSiCzech - Thursday, May 16, 2019 8:31 PM | Last reply by RoSiCzech - Friday, May 17, 2019 9:12 AM -
0 Votes
Extracting Date from Datetime (Datetype)
SameerMughal said: its ok mate it just works fine.Answered | 20 Replies | 4331 Views | Created by SameerMughal - Tuesday, January 13, 2009 12:17 PM | Last reply by SameerMughal - Wednesday, January 14, 2009 1:13 PM -
0 Votes
How to get year, month and day from server
You can go through this page which explains the convert function with regards to Date datetype.Answered | 3 Replies | 3172 Views | Created by Jessenchow - Thursday, February 23, 2012 4:39 AM | Last reply by Murali_CHN - Thursday, February 23, 2012 5:03 AM - Items 1 to 20 of 2007351 Next ›
No announcements
