473,785 Members | 2,457 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

converting general date format data into short date format

hello, i am doing a date comparation and i have reallize that the data
i have in my database (general date format) it is causing me problems,
and because i don´t need the time data i would like to convert all the

general date data into short date format, so i would like to delete the

time part of the data, it is any way i can do that ????
Thank you in advance and sorry for my english
carlos

converting general date format data into short date format

Nov 27 '06 #1
2 7010
to delete the "time" portion of a date/time value, you can use an Update
query, as

UPDATE TableName SET TableName.DateT imeField =
DateValue([TableName].[DateTimeField]);

replace TableName and DateTimeField with the correct names of the table and
date/time field in the table, of course. i strongly recommend that you back
up your database before running the Update query; it pays to be safe with
your data.

to ensure that all *new* values entered in the field do not include a
specific time, make sure you use the Date() function rather than the Now()
function anywhere that you set the value of the field in any record.

hth
"savigliano " <sa********@gma il.comwrote in message
news:11******** **************@ l12g2000cwl.goo glegroups.com.. .
hello, i am doing a date comparation and i have reallize that the data
i have in my database (general date format) it is causing me problems,
and because i don´t need the time data i would like to convert all the

general date data into short date format, so i would like to delete the

time part of the data, it is any way i can do that ????
Thank you in advance and sorry for my english
carlos

converting general date format data into short date format
Nov 27 '06 #2
thank you very much i will try it
carlos

Nov 27 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
1988
by: Tobias Müller | last post by:
Hello everybody, I've got some weather data from my local wx station and want to display this as a short table by using a XSL template. The data looks like <?xml version="1.0"?> <weather-data> <station name="external temp." sensor="3" type="temperature" unit="°C"> <datum date="04.09.2005" time="12:00" value="10" />
3
1398
by: Gary Smith | last post by:
I my SQL Datareader I am loading the date data into text box. Here is my code txtActOpenDate.Text = MyDataReader("ActOpenDt").ToString() txtActOpenDate.Text is displaying the date and time. How to display the date alone here. Thanks for your advice.
6
4439
by: yoshitha | last post by:
hi db : sql server 2000 lan : C#.net(ASp.Net) in my database table there are 2 fileds of data type datatime. in field 1 i'm storing date in field 2 i'm storing time.
4
3334
by: Dan Lewis | last post by:
I've imported a ms access database into a table in a mysql database. The access database contains a field that holds date/time values in 'general date' format. These all show up at 01/01/1970 in the mysql database. I believe the field in mysql is wanting UTC and shows numbers when looked at from the sql command line (i.e. March 13, 2006, 5:31 pm is shown as 1142289086). How do I get the access data into that format so it will import...
20
35637
by: andreas | last post by:
When I copy a vb.net project using date formats from one PC with a windows date format f.e. dd/mm/yyyy to another PC having a format yy/mm/dd then I get errors. How can I change for a while in the project the date format in vb.code ( not in Windows) and how can I find out which date format the PC Windows is using. Thanks for any response
3
2478
by: andrew | last post by:
Hi, I am trying to develop a database that will store dates in the format - 21.02.2006 rather than the standard 21/02/2006. This is because of the SAP feeds that i am pulling in - since SAP stores dates as dd.mm.yyyy I would just store the dates as text but this makes processing the data much harder.
8
4429
by: Ryan | last post by:
Hello, I'm new to Access and DB's in general. I've taken over some light duty support for a lab information system we use in house. Most of our dates are reported as "10/31/2006 12:30:00 PM" (With seconds listed in the report field). However, nobody wants to see the seconds. So I tried to format it =Format(DateCollected, "mm/dd/yy hh:nn AM/PM"). Works great, right? Well.. yeah for the most part. However if we
2
11184
by: Brian Parker | last post by:
I am beginning to work with VB2005.NET and I'm getting some problems with string formatting converting an application from VB6. VB6 code:- sTradeDate = Format(pArray(4,i Record), "mmddyy") pArray is a variant array containing a date string at pArray(4, iRecord) in the format "yyyy/mm/dd"
2
3426
by: CORTHOM | last post by:
If any one that can help me I have this simple database that I need to gather information and sort depending on carrier. A field in one of the tables is set up for general date format and I need to create a query to update the field to short date. I figured this is the only way since the information is being imported from excel in general date format. If any one can help that would be greatly appreciated Im a beginner and this seems to...
0
10325
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10147
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10091
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9950
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6739
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5381
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5511
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4050
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3645
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.