No announcements
Found 3888944 threads
-
0 VotesHow to save data from gridview into another sql table?
I am trying to make this implementation for saving data to an intersection table but displaying first the data from one of its ...Answered | 1 Replies | 40 Views | Created by Anonymous - Friday, March 31, 2017 10:04 PM | Last reply by Anonymous - Sunday, April 2, 2017 8:25 AM
-
1 Votes
SSIS Data Conversion String (09/09/2009 12:32:32 PM) to Date (09/09/2009)
can you try the Derived Column Transfromation (to convert to Date values) with either one of following expression dbDate_Output (if you want as Date ) : ...Answered | 1 Replies | 599 Views | Created by TWoW2017 - Friday, September 9, 2016 9:46 PM | Last reply by msbi_Dev - Friday, September 9, 2016 10:39 PM -
1 Votes
how to convertion of string into 12 and 24 hours format
I need to convert the value into 12 hrs (with AM PM) and 24 hrs format as per the setting.Answered | 7 Replies | 2505 Views | Created by Baba urf Murari - Tuesday, January 10, 2017 11:18 AM | Last reply by --CELKO-- - Tuesday, January 10, 2017 10:07 PM -
2 Votes
converting 24 hour clock to a 12 hour clock
If you also need special case handling for noon and midnight, then the best way is probably to create a 24-row 2-column table with the 24 numbers and ...Answered | 6 Replies | 15495 Views | Created by DaveDB - Friday, December 11, 2009 7:57 PM | Last reply by Hugo Kornelis - Friday, December 11, 2009 8:56 PM -
0 Votes
Last 24 hour data
Hi, I think this is how it should be create table test(id0 int, id1 int, occured datetime,id2 ...Answered | 1 Replies | 7171 Views | Created by moonstarlight2012 - Wednesday, September 22, 2010 8:59 AM | Last reply by GURSETHI - Wednesday, September 22, 2010 12:51 PM -
2 Votes
Parametrize utc time and last one day data in stored procedure.
The example shown will retrieve records in the last 24 hours from the UTC date, when you say you need from 00:00:00 - 11:59:59 the previous day, I presume you mean ...Answered | 3 Replies | 4260 Views | Created by EverydayLearner - Thursday, September 10, 2009 3:52 PM | Last reply by Justanewone - Friday, September 11, 2009 8:29 AM -
0 Votes
how to save 12 bits image data to XML?
Save your images in Sql Server.Answered | 8 Replies | 3111 Views | Created by Tammt - Sunday, November 2, 2008 5:51 AM | Last reply by Tammt - Wednesday, November 5, 2008 4:36 PM -
0 Votes
Is there a formula or function to change 24 hour time to 12 hour time am/pm?
this is so buried but happy it was posted.Answered | 3 Replies | 20627 Views | Created by BigEJ - Friday, February 12, 2010 8:21 PM | Last reply by DTGrayston - Thursday, January 12, 2012 1:27 AM -
0 Votes
Conversion of Datetime from 12 hours to 24 hours format
what is the problem if you pass the date into sql with out 24 hour format?Answered | 18 Replies | 12102 Views | Created by Kiran_msk - Monday, December 26, 2011 6:54 AM | Last reply by Kiran_msk - Monday, December 26, 2011 11:17 AM -
0 Votes
How to save DateTime with AM/PM
I have a textbox from which user can select date in `dd/mm/yyyy`, a dropdownlist with Hours as `1am,2am.....2pm,3pm....` and so on ,also a dropdown to select minutes `00,30`.Answered | 1 Replies | 4026 Views | Created by Ishan_h - Saturday, August 25, 2012 11:28 AM | Last reply by Werner van der Bank - Monday, August 27, 2012 8:24 AM -
0 Votes
need time part from datetime column with AM/PM format in SQL 2008
Those data types are present in 2008.Answered | 6 Replies | 14668 Views | Created by Yazdani ISTS - Thursday, September 5, 2013 11:26 AM | Last reply by disssss - Thursday, September 5, 2013 8:51 PM -
0 Votes
Killed\Rollback opretion is get stuck from last 24 hours.
I have killed the Query which is using linked server and from last 2 days it is in Rollback state.Answered | 10 Replies | 30105 Views | Created by Pradeep Madheshiya Microsoft(MSFT) - Friday, September 13, 2013 8:31 AM | Last reply by Erland Sommarskog - Monday, September 24, 2018 9:06 PM -
0 Votes
Last 24 months
You'll need two separate calendar tables to do this.Answered | 1 Replies | 676 Views | Created by kowssri - Thursday, June 16, 2016 5:05 PM | Last reply by Michiel Rozema - NL - Friday, June 17, 2016 9:54 AM -
1 Votes
how to show data for 24 hours on whole day in SQL
Pls note that in my sample table itself, there are 2 employees - Sanjay and Rahul present :) Thanks, Jay <If the post was helpful ...Answered | 7 Replies | 3357 Views | Created by LuckyAbd - Monday, January 27, 2014 7:35 AM | Last reply by Jayakumaur (JK) - Monday, January 27, 2014 10:41 AM -
1 Votes
Get last 24 hours worth of data
SELECT [ID], [Name], [Date] FROM [Table1] WHERE [Date] BETWEEN DATEADD (DAY , -1 , GETDATE()) AND ...Answered | 1 Replies | 3097 Views | Created by Milli_22 - Monday, January 23, 2012 3:08 AM | Last reply by Vishal Gajjar - Monday, January 23, 2012 3:17 AM -
1 Votes
how to transfer data from one table to another
The copy method of DataTable copies structure and data of the table.Answered | 3 Replies | 1851 Views | Created by Swaraj Kumar Panigrahi - Thursday, February 9, 2012 5:15 AM | Last reply by Helen Zhou - Monday, February 13, 2012 6:27 AM -
1 Votes
how to compare row data with another row in same table in SQL2014
Join the two tables...Answered | 5 Replies | 752 Views | Created by satwick - Wednesday, April 8, 2015 1:25 PM | Last reply by Jason A Long - Wednesday, April 8, 2015 3:15 PM -
1 Votes
Job Schedule Properties missing am/pm or 24 hr options on time
I'm unsure if this has been fixed in later releases of Management Studio 2008, but it's an issue with either Management Studio 2005 or 2008.Answered | 6 Replies | 9069 Views | Created by cysworks2 - Thursday, September 4, 2008 11:43 PM | Last reply by Jim McLeod - Sunday, August 23, 2009 11:40 PM -
0 Votes
Retrieve last 12 months data
cant seem to retrieve any data using the getdate() my date field is a DATETIME datatype and below are some examples of how the data looks ...Answered | 5 Replies | 36777 Views | Created by Sam233 - Thursday, March 24, 2011 9:27 AM | Last reply by Sam233 - Thursday, March 24, 2011 9:38 AM -
0 Votes
SQL QUERY FOR RECORD COMPARISONS WITHIN A TABLE
I see that Naomi responded and you have another thread with two posts already.Answered | 13 Replies | 4289 Views | Created by prvnkreddy - Tuesday, November 17, 2009 2:58 PM | Last reply by Abdshall - Wednesday, November 18, 2009 2:53 AM - Items 1 to 20 of 3888944 Next ›
No announcements
