No announcements
Found 3748198 threads
-
4 VotesDate time is not properly save in database
you can make the datatype of the field as DateTime in sql.Answered | 4 Replies | 2247 Views | Created by WASI UDDIN BAN - Monday, August 27, 2012 10:04 AM | Last reply by Joon84 - Monday, August 27, 2012 10:28 AM
-
0 Votes
get pure date and time from a date time value
You will be sorry with the approach of having a seperate date and time fields.Answered | 5 Replies | 1489 Views | Created by sourises - Tuesday, September 10, 2013 2:26 PM | Last reply by Sarat (SS) - Tuesday, September 10, 2013 3:25 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 | 13036 Views | Created by techneer - Friday, October 1, 2010 8:24 PM | Last reply by Sandip Patil - Saturday, October 2, 2010 8:49 AM -
1 Votes
Get current date and time
The ExecuteScalar is meant to select one value from the database.Answered | 17 Replies | 4132 Views | Created by brownie yeo - Thursday, September 29, 2011 5:13 AM | Last reply by brownie yeo - Friday, September 30, 2011 12:15 AM -
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 | 482 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 -
0 Votes
Date Time Field
Hi Devin, Is the IncidentDateTime field created based on the default Date&Time type?Answered | 1 Replies | 1370 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
Convert a Date Time field to a Time Field
Add a calculated field "CallMinutes" and convert your date (call time) to minutes using this expression = Hour(Fields!Answered | 4 Replies | 1934 Views | Created by De Dancey - Thursday, February 28, 2013 11:20 AM | Last reply by De Dancey - Friday, March 1, 2013 12:12 PM -
0 Votes
Need to merge/combine a seperate date and time field into DateTime on SQL Server
Here is a UDF that can be used inline to combine date and time fields.Answered | 4 Replies | 19737 Views | Created by Ars_Maxer - Thursday, September 4, 2008 9:37 PM | Last reply by Todd W. Powers - Thursday, October 16, 2008 9:41 PM -
0 Votes
to save date depending on time
its only example i told..dates are changing day by day..means it is not constant..i want to check it with date variable.. plz help meAnswered | 5 Replies | 437 Views | Created by Mousmi Nishad - Wednesday, March 16, 2016 6:59 AM | Last reply by Mousmi Nishad - Friday, March 18, 2016 10:24 AM -
1 Votes
Display only the date part of a date & time field?
Pls take a look select getdate(),convert(date, getdate()), convert(date,t.dt) from (select getdate() as dt) as tAnswered | 5 Replies | 2163 Views | Created by Darts75 - Monday, March 17, 2014 2:12 AM | Last reply by KEAARPEE - Monday, March 17, 2014 2:22 PM -
0 Votes
Cannot delete data from a date/time field
The Parse event is what controls what gets saved back to the databound item (in other words, gets saved back to the column in your DataTable).Answered | 18 Replies | 1521 Views | Created by RONATMOODYLAKE - Tuesday, October 22, 2013 7:10 PM | Last reply by BonnieB - Saturday, November 2, 2013 3:40 PM -
3 Votes
Prompt User for a date in a query using date time field
Just for completeness, the overriding reason to use Andrey's or Doug's second approach is that using a function such as Int or DateValue on the date/time ...Answered | 6 Replies | 3066 Views | Created by Doug77546 - Sunday, October 16, 2011 5:25 AM | Last reply by Marshall Barton - Sunday, October 16, 2011 4:37 PM -
0 Votes
time is getting appended with date of birth
Hi ashish_ni90, Per my understanding that you have a fields "Birth" which is Date type but when display in the report, it display ...Answered | 2 Replies | 619 Views | Created by ashish_nj90 - Wednesday, December 17, 2014 10:05 AM | Last reply by Vicky_Liu - Thursday, December 18, 2014 6:04 AM -
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 | 15819 Views | Created by Yasser Salah2 - Thursday, February 28, 2013 9:29 PM | Last reply by Yasser Salah2 - Saturday, March 2, 2013 7:43 PM -
0 Votes
How to set the time part of a date/time field?
Hi please check this ...Answered | 3 Replies | 745 Views | Created by Nahcyrret - Thursday, July 28, 2016 8:53 AM | Last reply by Victoria Xia - Wednesday, August 3, 2016 11:09 AM -
6 Votes
Standardizing date time.
So you can see here the problem when the data from outletID=2 and outletID=3 are updated into central db and when I do an order by date time.Answered | 15 Replies | 7617 Views | Created by a.net sukbir - Monday, March 15, 2010 7:43 AM | Last reply by a.net sukbir - Thursday, March 25, 2010 5:21 AM -
0 Votes
Date VS Date Time in Calculated Field
When is a leap year not a leap year He recommends all date time math be done strictly with libraries.Answered | 10 Replies | 918 Views | Created by reigh7 - Monday, January 12, 2015 11:43 PM | Last reply by reigh7 - Tuesday, January 20, 2015 8:23 PM -
0 Votes
Odd Date for Current Date and Time
http://sharepointsolutions.com/sharepoint-help/blog/2011/04/how-to-add-and-subtract-hours-and-minutes-from-date-and-time-fields-in-sharepoint-lists/Answered | 3 Replies | 1231 Views | Created by bushman1957 - Wednesday, April 30, 2014 8:14 PM | Last reply by Alex Brassington - Thursday, May 8, 2014 3:49 PM -
2 Votes
Date time with created date column
Hi Priviya.P, Using AT TIME ZONE clause converts it into the target time zone using the time zone conversion rules.Answered | 2 Replies | 1060 Views | Created by PriviyaBelieves - Monday, June 24, 2019 10:20 AM | Last reply by Cathy Ji - Tuesday, June 25, 2019 8:12 AM -
1 Votes
Date and Time Format Problem
Voila ... format independent date time management, a database where points in time (excluding daylight savings) can be compared as ...Answered | 19 Replies | 7615 Views | Created by lucerias - Tuesday, January 23, 2007 7:24 AM | Last reply by Joe Babu - Wednesday, January 31, 2007 2:12 PM - Items 1 to 20 of 3748198 Next ›
No announcements
