Merge Data and Time

[softpro]

Hi I have date and time value together. Want to merge it and store it in the database.

Please let me know how to handle this.

Thanks in advance.

 

[Jack Cowley]

Hmmm. Not sure what you have as you say you have a date and time 'together' and you want to 'merge' them into a database. Are they in a spreadsheet? Text file?

A bit more detail on what you have and what you want to do will help someone here to help you, but your information is to vauge at the moment.

Jack

 

[softpro]

Thanks Jack,

Actually I have date and time in separate fields, I want to merge and store it in the database.

 

[Jack Cowley]

If it were me I would not merge the date and time but keep them in separate fields. Getting time or date information from a field that has the time and the data is more difficult than doing them separately. If you want to show them as a single field you can do that with concatenation but I would not combine the data. My humble opinion....

Jack

 

[softpro]

Thanks Jack!

 

[Jack Cowley]

You are welcome. Just know that it is never a good idea to put more than one piece of data in a field.

Good luck with your project....

Jack