No announcements
Found 2526037 threads
-
1 VotesDateTime fields only showing date, not time
Becasue While creating Field if you select Date Only, then in List View it will only show Date in that field.Answered | 6 Replies | 13070 Views | Created by five13 - Monday, August 31, 2009 2:48 PM | Last reply by five13 - Tuesday, September 1, 2009 6:50 AM
-
1 Votes
Display only the date part of a date & time field?
You will be out of luck for getting date only type with convert/cast and you have to use convert to do it in SQL end.Answered | 5 Replies | 2328 Views | Created by Darts75 - Monday, March 17, 2014 2:12 AM | Last reply by KEAARPEE - Monday, March 17, 2014 2:22 PM -
0 Votes
getting time and date from datetime field in javascript
Hello guys, I need to get hours from the difference between two datetime fields.Answered | 2 Replies | 13207 Views | Created by techneer - Friday, October 1, 2010 8:24 PM | Last reply by Sandip Patil - Saturday, October 2, 2010 8:49 AM -
0 Votes
update datetime to date only
A DATETIME column always has a time portion.Answered | 7 Replies | 12345 Views | Created by Mr.Khaled - Monday, August 8, 2011 10:37 AM | Last reply by RichardTheKiwi - Tuesday, August 9, 2011 2:45 AM -
1 Votes
show only date (no time)
You can use CAST or CONVERT the DATETIME to DATE to get rid of the time part SELECT ModifiedDate, ...Answered | 4 Replies | 1084 Views | Created by OldSoul9 - Sunday, November 9, 2014 6:23 PM | Last reply by Satheesh Variath - Monday, November 10, 2014 5:25 AM -
0 Votes
Converting Date field & Character Time field to a DateTime field
May not be the best possible way, but this seems to work: dateandtime=CTOT(DTOC(DATE())+" "+TIME()) You could substitute your ...Answered | 3 Replies | 8009 Views | Created by Jonathan Morningstar - Tuesday, October 22, 2013 3:38 PM | Last reply by KevClark64 - Tuesday, October 22, 2013 5:09 PM -
2 Votes
Search only by date not with datetime
I was too fast on the submit :) The statement select dateadd(dd, datediff(dd,0, getDate()), 0); Gives you the truncated of current ...Answered | 7 Replies | 1951 Views | Created by Mohammed Abdul Muqeet - Wednesday, November 28, 2012 12:32 PM | Last reply by RajivCRM - Sunday, December 2, 2012 12:57 PM -
0 Votes
Date Time Field
Hi Devin, Is the IncidentDateTime field created based on the default Date&Time type?Answered | 1 Replies | 1573 Views | Created by Devin McMahon - Wednesday, June 10, 2015 1:08 AM | Last reply by Wendy DZ - Thursday, June 11, 2015 2:47 AM -
0 Votes
Remove time from datetime field
@Guiherme Bueno thanks a lot taking time to try to solve my problem although I can not use your suggestion since I need the date and the ...Answered | 5 Replies | 9499 Views | Created by lara morrisson - Tuesday, July 12, 2011 1:22 PM | Last reply by AbedKhooli - Wednesday, July 13, 2011 6:51 PM -
0 Votes
Convert Datetime field to display date
Although if your date time field is datetime type, then you don't need to do any conversion, you need to use ISO date format for dates to compare ...Answered | 9 Replies | 14004 Views | Created by tammali - Wednesday, August 9, 2006 6:09 AM | Last reply by Kalman Toth - Thursday, September 8, 2011 4:30 AM -
0 Votes
How to create field to show time as HH:MM:SS (no date - just time)
Access DateTime stores a point-in-time, not a duration of time.Answered | 6 Replies | 4551 Views | Created by Mel_3 - Wednesday, June 15, 2011 3:42 PM | Last reply by Mel_3 - Wednesday, June 15, 2011 6:46 PM -
2 Votes
How Can i save date without time in datetime field
As Sean says, you can't store just the date in a DATETIME field.Answered | 5 Replies | 16362 Views | Created by Yasser Salah2 - Thursday, February 28, 2013 9:29 PM | Last reply by Yasser Salah2 - Saturday, March 2, 2013 7:43 PM -
3 Votes
Datetime from date and time
If DateTimePicker1 has the date and DateTimePicker2 has the time then an alternative to IronRazer's approach.Answered | 2 Replies | 652 Views | Created by Y a h y a - Saturday, August 15, 2015 10:45 AM | Last reply by dbasnett - Sunday, August 16, 2015 11:50 AM -
3 Votes
Get DATE from DATETIME field
if you are using SQL Server 2005, only date or only time data types are not there. even if you extract the date some how and store it in the ...Answered | 7 Replies | 45258 Views | Created by Sam233 - Friday, July 29, 2011 9:24 AM | Last reply by Surendra Nath GM - Friday, July 29, 2011 9:49 AM -
4 Votes
Table Design With Date, Time, and Datetime
Assuming that the date and time columns are in fact recording the "time" that an action occurred, I would use a datetime (or smalldatetime) column ...Answered | 5 Replies | 8924 Views | Created by Matt Keyes - Saturday, July 31, 2010 1:08 PM | Last reply by Matt Keyes - Saturday, July 31, 2010 7:19 PM -
3 Votes
Query DateTime field by date range
= cast(<enter start date here> as date) and StartDate < cast(<enter end date here> as date); Thanks, ATAnswered | 4 Replies | 808 Views | Created by scott_m - Wednesday, December 2, 2015 7:15 PM | Last reply by Aishwarya Tripathi - Wednesday, December 2, 2015 7:47 PM -
0 Votes
Date only and time only values
If you split your datetime column to date and time, you need two new columns to keep the same data.Answered | 3 Replies | 664 Views | Created by Y a h y a - Thursday, July 20, 2017 8:30 PM | Last reply by Jingyang Li - Thursday, July 20, 2017 9:11 PM -
0 Votes
Converting time and date to datetime in UTC
hour 43 => minutes 50 => seconds 000 => ...Answered | 4 Replies | 4180 Views | Created by infused - Monday, June 6, 2011 9:36 AM | Last reply by Sudip_inn - Tuesday, January 24, 2017 2:00 PM -
0 Votes
SQL Date field also showing time in SSRS Dataset
Just as you said, you can change the text-box format on each report, and I am afraid you have to do it manually if you want to display date only.Answered | 3 Replies | 3362 Views | Created by Harmelin1 - Wednesday, August 1, 2012 7:22 PM | Last reply by Charlie Liao - Friday, August 3, 2012 2:11 AM -
0 Votes
Converting all datetime fields to datetime2 and date
One thing that you can do to datetime but not to the new date-related types are things like dateval + 2, you would have to use DATEADD() instead.Answered | 7 Replies | 4125 Views | Created by bagman3rd - Wednesday, January 6, 2010 4:23 PM | Last reply by Naomi N - Wednesday, January 6, 2010 6:27 PM - Items 1 to 20 of 2526037 Next ›
No announcements
