Insert Time Now()

This topic is locked

Insert Time Now()	3/6/2008 5:25:40 AM
PHPRunner General questions
S swanside author Hello. On my project I have a job table with the following fields. `SELECT job.Order_Date, job.File_No, job.Job_No, job.Customer_ID, job.Order_Time, job.Contract, job.Order_Site_Address, job.Job_Description, job.VAT, job.Invoice_Printed, job.Invoice_Printing_Date, job.Invoice_Tax_Date, job.Payment_Received, job.Job_Finished, job.CustomerRef, job.Customer_Name, job.Payment_Due_date, job.Payment_Date, job.Locked, job.Note, labour.Engineer_Name FROM job left join labour on job.Job_No = labour.Job_No` On the job view in Visual Editor, I want to look at my add page, I have Order_Date, File_No, Order_Time, Contract, Order_Site_Address, Job_Description. On the Order_Date I double click and select Edit as Date Dropdown Boxes with Date Picker and in the Default box, I enter now() On the Order_Time I double click and select Edit as Time and in the default box, I enter now() WHen I run the program, and select the add page the date is correct in the Order_Date, but in the Order_Time is shows the date in reverse and no time. i.e. 2008:03:06 How can I get this Order_Time to just show the current time and not the date? Thanks Paul.


S	swanside author 3/6/2008
	It OK sorted it now. I select the field in the Visual Editor. Edit as Date and select simple edit box. and in the default value I entered date('H:i:s'); and it works OK. Thanks