No announcements
Found 3147047 threads
-
0 VotesChange varchar column with numbers(290119) to date column(ddmmyyyy)
Would it then be possible to cast/convert varchar to a date in the same select?Answered | 5 Replies | 1080 Views | Created by ThenewbieD - Thursday, May 16, 2019 6:03 AM | Last reply by - Tuesday, May 21, 2019 12:49 PM
-
0 Votes
changing date format from DD.MM.YYYY to DDMMYYYY in derived column
how to change date format from DD.MM.YYYY to DDMMYYYY in derived columnAnswered | 1 Replies | 1198 Views | Created by roy12345 - Tuesday, May 21, 2013 6:35 PM | Last reply by ArthurZ - Tuesday, May 21, 2013 6:40 PM -
13 Votes
Convert a date column to YYYYMMDD format.
Hi CELKO, The date format was fine, it is just a date column; no string attached.Answered | 11 Replies | 416421 Views | Created by BIAnalyst - Sunday, March 3, 2013 11:34 PM | Last reply by Jeff Moden - Tuesday, June 23, 2020 3:55 PM -
0 Votes
how to convert the date column data
hi, how to convert the date column ...Answered | 7 Replies | 5920 Views | Created by Eveta - Tuesday, July 20, 2010 6:47 PM | Last reply by Hunchback - Tuesday, July 20, 2010 7:20 PM -
0 Votes
Convert DDMMYYYY to MMDDYYYY (Datetime)
The date and time data is stored in the DATETIME datatype in an internal format irrespective of the display format.Answered | 4 Replies | 3600 Views | Created by Prabhuvincent - Friday, July 26, 2013 4:53 AM | Last reply by Krishnakumar S - Friday, July 26, 2013 5:24 AM -
0 Votes
Converting Date columns
example : CONVERT(VERCHAR(10),DATECOLUMN,112) will give you the output in YYYYMMDD ...Answered | 3 Replies | 649 Views | Created by KS2909 - Monday, February 8, 2016 10:06 PM | Last reply by Ponraj Paul - Tuesday, February 9, 2016 5:36 PM -
1 Votes
Convert date format in SSIS
How would i add a padding 0 infront of the days let say i got a date showing one digit on the date ?Answered | 6 Replies | 12491 Views | Created by brucelim80 - Monday, August 12, 2013 1:23 AM | Last reply by arkiboys - Thursday, July 24, 2014 6:49 AM -
1 Votes
Different Date Formats in Columns
Paul SELECT CONVERT(VARCHAR(15),CAST('1971-02-20'AS DATETIME),101) Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ ...Answered | 2 Replies | 5257 Views | Created by pjscott51 - Monday, June 13, 2011 12:24 PM | Last reply by Uri Dimant - Monday, June 13, 2011 12:37 PM -
0 Votes
change datagridview column date format
The conversion of dates in a rowfilter is really fiddly.Answered | 3 Replies | 3350 Views | Created by BONIETE - Monday, January 11, 2016 2:07 PM | Last reply by Barry Wang - Thursday, January 21, 2016 9:09 AM -
5 Votes
How to convert date column to a string
Hi Lucki, According to your description, you want to convert an integer column with date value into two columns, one contains year part, another ...Answered | 5 Replies | 888 Views | Created by lucki2005 - Wednesday, November 11, 2015 10:42 AM | Last reply by Katherine Xiong - Friday, November 13, 2015 1:51 AM -
0 Votes
how to convert date in number in to datetime specific format
try to pass the date in yyyymmdd format, it is easier this way.Answered | 4 Replies | 3099 Views | Created by hygrsrir1987 - Wednesday, December 19, 2012 9:32 AM | Last reply by Satheesh Variath - Wednesday, December 19, 2012 10:19 AM -
0 Votes
Convert date and merge the number column in sharepoint column
Hi ahmriz, You can create a new calculated column with the following formula in the list.Answered | 1 Replies | 5129 Views | Created by ahmriz - Friday, April 26, 2013 3:14 PM | Last reply by star.wars - Monday, April 29, 2013 9:20 AM -
1 Votes
DataGridView Date column formatting
Just this this simlpe example and it does work: Public Partial Class Form1 Inherits Form Private table As DataTable Public Sub ...Answered | 4 Replies | 23628 Views | Created by Hazrit - Friday, August 12, 2011 4:00 PM | Last reply by Mitja Bonca - Friday, August 12, 2011 7:58 PM -
0 Votes
Convert column from string to date
Hi You convert the requested date to a string and specify the format number corresponding to the format needed.Answered | 17 Replies | 2528 Views | Created by AsmaGh - Tuesday, February 19, 2019 8:31 AM | Last reply by AsmaGh - Thursday, February 21, 2019 8:25 AM -
2 Votes
Date formatting
I have different dates in the table and I want the output to get those dates but with same formatting.Answered | 7 Replies | 960 Views | Created by rotary Outsourcing - Monday, February 2, 2015 9:45 PM | Last reply by Jingyang Li - Tuesday, February 3, 2015 3:26 AM -
1 Votes
How to format datagridview single column to date
Or you can specify the format for particualt column of DGV: dataGridView1.Columns(0).DefaultCellStyle.Format = ...Answered | 3 Replies | 2771 Views | Created by Saseendran Kombath - Saturday, October 1, 2011 3:28 AM | Last reply by Saseendran Kombath - Saturday, October 1, 2011 3:29 PM -
3 Votes
How to Format a Date Column in a datgridview where data is double format?
How would I do That?Answered | 5 Replies | 2751 Views | Created by TS68 - Monday, August 3, 2009 6:37 PM | Last reply by TS68 - Saturday, August 8, 2009 3:48 AM -
1 Votes
Converting a date column
declare @slop table(slopDate varchar(25)) insert into @slop select 'May 24 1980 12:00AM' union all select 'Feb 10 1963 12:00AM' union ...Answered | 4 Replies | 3714 Views | Created by Zoe.Ohara - Monday, March 9, 2009 8:22 PM | Last reply by Kent Waldrop _ - Monday, March 9, 2009 9:33 PM -
0 Votes
Need help with displaying date column in different format
There is no format involved in this.Answered | 3 Replies | 754 Views | Created by StudentQCC - Wednesday, September 21, 2016 2:21 PM | Last reply by StudentQCC - Wednesday, September 21, 2016 3:28 PM -
0 Votes
How to convert string date type in derived column
the DATE type 08/12/2011 <Answered | 7 Replies | 3679 Views | Created by Dana70 - Wednesday, October 5, 2011 4:32 PM | Last reply by --CELKO-- - Wednesday, October 5, 2011 10:32 PM - Items 1 to 20 of 3147047 Next ›
No announcements
