No announcements
Found 3748076 threads
-
0 VotesMerging Date and Time fields in table for datediff/dateadd calculation
Based on your example, date is 4/23/2018 and start time is 1:00 PM and end time is 3:00 PM and the query run time is 4/24/2018 2:00 PM, ...Answered | 14 Replies | 506 Views | Created by JHarding08 - Tuesday, April 24, 2018 7:04 PM | Last reply by Ken Sheridan - Thursday, April 26, 2018 10:43 AM
-
4 Votes
Trouble calculating date/time between two dates.
Alot of the trouble is that this is a remedy database and all times are stored in unix time from a UTC time.Answered | 13 Replies | 11265 Views | Created by DblR - Thursday, October 28, 2010 10:12 PM | Last reply by Mohamed Irshad - Thursday, December 2, 2010 4:02 AM -
4 Votes
Get Compile date and time in application
during mst summer time I get 13hrs+20'ish minutes+?Answered | 13 Replies | 25732 Views | Created by Ali Reza Pooneh - Wednesday, September 2, 2009 5:14 PM | Last reply by fs - ab - Saturday, August 20, 2011 4:21 AM -
0 Votes
Update Date time in the database for Eastern standard time
I've a friend who lives there, and works over the time zone 'line' She leaves for work at 9am, and arrives at 9am.Answered | 7 Replies | 852 Views | Created by Nideesh - Wednesday, August 20, 2014 1:46 PM | Last reply by Erland Sommarskog - Wednesday, August 20, 2014 9:54 PM -
1 Votes
DateTime 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 | 12696 Views | Created by five13 - Monday, August 31, 2009 2:48 PM | Last reply by five13 - Tuesday, September 1, 2009 6:50 AM -
0 Votes
Date and Time from Getdate
--CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in SQL ...Answered | 9 Replies | 2012 Views | Created by Mandavas7 - Monday, April 29, 2013 5:00 PM | Last reply by --CELKO-- - Monday, April 29, 2013 7:39 PM -
0 Votes
Using Date/Time with Javascript.
I have made a breakthrough in the Date/Time saga.Answered | 8 Replies | 1884 Views | Created by tbensen - Friday, May 12, 2017 9:01 PM | Last reply by tbensen - Thursday, May 18, 2017 5:22 PM -
0 Votes
Date time format in date time picker
Amit Govil | Email "Weeks of coding can save you hours of planning"Answered | 3 Replies | 3947 Views | Created by Sanyon_d - Tuesday, February 21, 2012 5:18 AM | Last reply by Amit Govil (MCC) - Wednesday, February 22, 2012 5:58 AM -
0 Votes
Inserion of combobox,date,time into database
If you've done your database well, you should not use the date of the combobox to string.Answered | 3 Replies | 649 Views | Created by prave123 - Friday, July 4, 2014 2:20 PM | Last reply by Cor Ligthert - Monday, July 7, 2014 6:39 AM -
1 Votes
date time issue
Hi,Try a parameterised query... if the parameter type is datetime and you pass an actual date time value the formatting doesn't matter, because you're not passing a string but a ...Answered | 9 Replies | 2965 Views | Created by Rishi23 - Friday, October 2, 2009 12:40 AM | Last reply by Rishi23 - Friday, October 2, 2009 5:36 PM -
0 Votes
Problem saving a date to a date field
Hi all, I have a textbox and enter a date in it (European format).Answered | 2 Replies | 909 Views | Created by Mark Hofland - Tuesday, June 28, 2016 9:51 AM | Last reply by Dan Guzman - Tuesday, June 28, 2016 12:25 PM -
0 Votes
How to put date without day in Date & Time field
I believe in your Date & Time field, you are only displaying dates.Answered | 2 Replies | 5554 Views | Created by Anton Chetvergov - Friday, December 25, 2009 11:50 AM | Last reply by Marc D Anderson MVP - Sunday, December 27, 2009 2:43 AM -
2 Votes
Coverting UTC date time to local date time in sql server
However, if you want to convert it to the USER local time, this should be done in the client code, not in SQL Server.Answered | 8 Replies | 31990 Views | Created by Sudip_inn - Tuesday, January 24, 2017 1:49 PM | Last reply by Tom Phillips - Wednesday, April 18, 2018 1:02 PM -
0 Votes
Merging date and SSN fields in Access
I have an Access query created that lists all doctors with the date of birth and the last 4 digits of the social security - these are 2 seperate fields and I need to ...Answered | 1 Replies | 1035 Views | Created by Claudette37 - Friday, March 8, 2013 4:28 PM | Last reply by Dirk Goldgar - Friday, March 8, 2013 6:23 PM -
0 Votes
Adding Date to Time
That action is for ADDING time/days to a date/time field.Answered | 9 Replies | 7757 Views | Created by JonHartZA - Tuesday, December 8, 2009 7:14 AM | Last reply by JonHartZA - Thursday, March 25, 2010 6:25 AM -
0 Votes
Date Time columns append
2. regardless of the answer to #1, you can build a clean time column by stripping the date part out of the original time column using the ...Answered | 2 Replies | 5381 Views | Created by san463 - Thursday, May 24, 2012 2:45 AM | Last reply by Brent Greenwood - Monday, May 28, 2012 2:30 AM -
0 Votes
Date only from date time value
I have a field that has a datetime format and I only want the date without time for a calculated field in the dataset.Answered | 3 Replies | 5981 Views | Created by jimb370 - Wednesday, June 1, 2011 6:17 PM | Last reply by Rajkumar Yelugu - Wednesday, June 1, 2011 6:54 PM -
0 Votes
Short date is including time
user typein, a default value property, code?Answered | 8 Replies | 6191 Views | Created by msdnPublicIdentity - Friday, July 2, 2010 2:12 PM | Last reply by John W. Vinson MVP - Wednesday, July 7, 2010 5:40 PM -
2 Votes
Date and Time fields wrong format on Custom DispForm.aspx
Just out of curiosity, is it a true Date/Time field or is it a Calculated Field?Answered | 5 Replies | 18574 Views | Created by rc.alex - Wednesday, April 11, 2012 4:11 PM | Last reply by Zaaraa - Monday, March 17, 2014 12:35 PM -
1 Votes
How do I save present time/date into a table from a form?
The typical solution would be that you set a Default Value for the TransactionDate field in your Transactions table.Answered | 1 Replies | 756 Views | Created by JimCosta - Wednesday, April 24, 2013 1:43 AM | Last reply by Tom van Stiphout (MVP) - Wednesday, April 24, 2013 2:11 AM
No announcements
