No announcements
Found 513212 threads
-
2 VotesDate formatting
I have different dates in the table and I want the output to get those dates but with same formatting.Answered | 7 Replies | 823 Views | Created by rotary Outsourcing - Monday, February 2, 2015 9:45 PM | Last reply by Jingyang Li - Tuesday, February 3, 2015 3:26 AM
-
0 Votes
Date Format
i tried to list date in "mm/dd/yyyy hh:mm:ss ampm" format through select query and tats works fine.Answered | 5 Replies | 10145 Views | Created by Jitendra M - Tuesday, June 8, 2010 1:37 PM | Last reply by Jitendra M - Friday, June 18, 2010 2:03 PM -
1 Votes
Date format
This is quite helpful when the input format is not consistent (this is to be expected when dealing with user input) and you want to be extremely tolerant.Answered | 3 Replies | 3530 Views | Created by Jackson_1990 - Monday, September 7, 2009 9:40 AM | Last reply by Wole Ogunremi - Monday, September 7, 2009 2:06 PM -
0 Votes
Date Formating
And generally, let the client get the data in it's native date type and let the client format the date.Answered | 4 Replies | 4547 Views | Created by Sanjay Dholakiya - Friday, June 5, 2009 8:03 PM | Last reply by Louis Davidson - Sunday, June 7, 2009 10:06 PM -
0 Votes
Date Format
1.You can modify the view of the view in SharePoint Designer to format the date &time column .Answered | 5 Replies | 2145 Views | Created by s.s.rameshram - Friday, October 11, 2013 11:12 AM | Last reply by Hemendra Agrawal - Monday, October 14, 2013 5:01 AM -
0 Votes
Date Format
Beside using the predefined formats, you can also use the user-defined formatting functions.Answered | 2 Replies | 3132 Views | Created by J-Bal - Friday, August 21, 2009 7:32 PM | Last reply by Jeff Shan - Monday, August 24, 2009 3:14 AM -
4 Votes
Date Format
There is no way you can distinguish this unless you use a common format to store all the dates.Answered | 9 Replies | 2208 Views | Created by vamsi1980 - Tuesday, June 5, 2012 11:36 AM | Last reply by Satheesh Variath - Tuesday, June 5, 2012 1:57 PM -
0 Votes
Date formatting
For me AU Dates are different from the states, so in my case when playing with the application I have created a computed column and then in the method for the column used .net code ...Answered | 2 Replies | 2549 Views | Created by Andrew Keil - Wednesday, December 8, 2010 3:10 AM | Last reply by Andrew Keil - Wednesday, December 8, 2010 11:10 AM -
0 Votes
Date Format
Ideally you should be doing this in front end as formating causes column to lose its native datatype and make it character based.Answered | 2 Replies | 853 Views | Created by AJ_25 - Monday, March 12, 2018 1:11 PM | Last reply by Visakh16 - Monday, March 12, 2018 1:50 PM -
0 Votes
Date Format
So Long Date format comes from your Windows setting, if it is different than what is standard(blame user), you might get different result.Answered | 4 Replies | 2984 Views | Created by dAryL-TaNayTech - Sunday, March 14, 2010 2:49 AM | Last reply by dAryL-TaNayTech - Sunday, March 14, 2010 7:21 AM -
4 Votes
Format Date
Don't - you let the consumer of your resultset format data for presentation.Answered | 3 Replies | 842 Views | Created by Bone_12 - Thursday, January 17, 2019 1:50 PM | Last reply by Emily Fei - Friday, January 18, 2019 7:12 AM -
0 Votes
Date Format
Is this date from a list item?Answered | 1 Replies | 1313 Views | Created by Bhawani Singh K - Monday, March 4, 2013 2:26 PM | Last reply by Jason Warren - Monday, March 4, 2013 2:47 PM -
0 Votes
date format
check-out below link http://www.sql-server-helper.com/tips/date-formats.aspx Regards, Ahmed Ibrahim SQL Server Setup Team ...Answered | 1 Replies | 3743 Views | Created by kztn - Thursday, May 10, 2012 6:51 AM | Last reply by Ahmed Ibrahim - MSFT - Thursday, May 10, 2012 6:56 AM -
4 Votes
date formats
To trap the error, just start with: =Format(Fields!Answered | 3 Replies | 5138 Views | Created by srinivasa rao yenninti - Tuesday, February 28, 2012 9:39 AM | Last reply by Leeroyster - Tuesday, February 28, 2012 2:45 PM -
1 Votes
Date table with Australian date format
SQL Server saves the date in a native (numeric) format.Answered | 4 Replies | 1388 Views | Created by toby_m31 - Friday, June 21, 2013 1:21 AM | Last reply by toby_m31 - Friday, June 28, 2013 1:05 AM -
0 Votes
Date formatting
Meanwhile, please refer to the following link: Custom Date and Time Format ...Answered | 4 Replies | 1542 Views | Created by kiloez - Sunday, February 5, 2012 7:27 AM | Last reply by Dummy yoyo - Tuesday, February 7, 2012 2:44 AM -
0 Votes
Date Format
If time is of no interest, use DATE data type to store dates.Answered | 7 Replies | 3372 Views | Created by sqlrooky - Sunday, September 25, 2011 12:33 AM | Last reply by Kalman Toth - Sunday, September 25, 2011 7:44 PM -
0 Votes
date format
Dates should be formated in the presentation layer, not in the database.Answered | 8 Replies | 1095 Views | Created by Dre01 - Friday, March 13, 2015 3:23 PM | Last reply by KEAARPEE - Tuesday, March 17, 2015 5:56 PM -
0 Votes
Date format
*/ More on datetime / date formatting ...Answered | 6 Replies | 4277 Views | Created by NSG12 - Tuesday, November 16, 2010 6:07 PM | Last reply by Kalman Toth - Sunday, November 21, 2010 8:14 AM -
2 Votes
Date format
See Date formats SQL ServerMangal Pardeshi BI SQL With MangalAnswered | 5 Replies | 4207 Views | Created by TMH- - Friday, July 31, 2009 6:15 AM | Last reply by Mangal Pardeshi - Friday, July 31, 2009 9:10 AM - Items 1 to 20 of 513212 Next ›
No announcements
