341 Topics

Member Avatar for
Member Avatar for sunny258

In recent years, open source software, and open source community construction is more popular, such as: mysql, postgresql, and openGauss database open source communities .So, as an individual, how to specifically participate in the open source community contribution?

Member Avatar for rproffitt
0
31
Member Avatar for sankar2000

The web application will have a database that consists of millions (over 20mil ... maybe 100mil or more) of hosts (ipv4,ipv6 and domains) and additional data to each host like blacklist, uptime, history, geo data (country, region, city, isp). I could, of course, use other RMDBS system like MySQL, Oracle, …

Member Avatar for john_111
0
72
Member Avatar for Reverend Jim

I have a SQLite database that for some insane reason stores dates as the number of days since 1899-12-31. I want to create a view that will display the date as an actual date. I can calculate a specific date from a specific day number as select date('1899-12-31','Localtime','+44386 day') as …

Member Avatar for Reverend Jim
0
732
Member Avatar for vegaseat

For those who are afraid of lycanthropes and full moons, here is a way to figure out the phase of the moon.

Member Avatar for Sichen
2
5K
Member Avatar for rproffitt

Here's the screen grab: ![50yearsAgoOnDaniweb.PNG](https://static.daniweb.com/attachments/1/9fb4572ed18ebec0e88c9822adaa0152.PNG) Here's the link to the 50 years ago reply: https://www.daniweb.com/posts/jump/ (doesn't work) Here's the link to the discussion: https://www.daniweb.com/programming/software-development/threads/523223/im-having-a-difficulty-in-a-program-in-c-net-framework Something happened. Don't know but interesting bug there.

Member Avatar for rproffitt
0
84
Member Avatar for sagisgirl

Hi, I am developing a system that need to monitor machines' licence, so i have a field 'movedate' and 'outdate' every machines can only been kept for 2 years for most. and if the machine didn't go out for almost 2 years, an alert will come out to remind the …

Member Avatar for Dani
0
8K
Member Avatar for Dani

I use `<input type="date">` and it works fine to bring up a date picker in Chrome and Firefox. However, it behaves as a normal textbox in Safari.

Member Avatar for rproffitt
0
43K
Member Avatar for Patiodude

I run a website where I periodically post articles. I'd like to add a timestamp/datestamp to each article showing the post date (the upload date, I assume, would be the logical choice). I had already asked for advice on this topic; unfortunately, the result is a blank. Literally. Here's an …

Member Avatar for Ty omotayoo
0
714
Member Avatar for johndohmen1963

I have a datagridvied with several columns and one with date and the format is Me.DataGridView1.Columns("Doopdatum").DefaultCellStyle.Format = "yyyy - MM - dd dddd" or Me.DataGridView1.Columns("Doopdatum").DefaultCellStyle.Format = "dddd dd - MM - yyyy" Depends on the button i press My problem is when i reverse from "yyyy - MM - dd …

Member Avatar for r310070
0
422
Member Avatar for Reverend Jim

Just for fun I went to the start of the [Word Association Game](https://www.daniweb.com/community-center/threads/302/word-association-game#post2075) thread. I noticed it was started 14 years ago but there seems to be a problem with the date order. Post 1 - 14 years ago - Lucy Post 2 - 13 years ago - cellphone --> …

Member Avatar for Dani
0
591
Member Avatar for shany0786

..... for (i = start_from; i < finish_by; i++) { var todayObj = new Date(); var current_hour = todayObj.getHours(); console.log(current_hour); var dateObj = new Date(date); if((dateObj.toDateString() == todayObj.toDateString()) && i<=current_hour){ /*no print*/ }else{ var time_in_12 = contvert_in_12_hours_time(i,(i+1)) content += '<div class="col-md-10 col-md-offset-1 avail_time">\n\ <input title="Book time slote" type="button" class="set_appoint_time unselected_time" …

0
165
Member Avatar for nitin1

Hi, I am stuck with a problem. I have two Date objects (util class objects). I want the difference between these two dates as the number of days between them? I am using Java 8. Can you please help me with this? Searched the web a lot. Some are saying …

Member Avatar for JamesCherrill
0
809
Member Avatar for Stefce

How can i get the end of the month or the beggining of the month to create a new table for records ? i have this code but it gets the current month... <?php $user = getUserData('users', 'UserUsername'); $sql = "SELECT `ticket_id`, `Uplata`, `Dobivka`, `Date` FROM `kladilnica` WHERE `Username`='$user'"; $result …

Member Avatar for Stefce
0
305
Member Avatar for calebcook

Hi. I need to be able to display each day of the current month excluding Sunday in a format: month/day (eg. 11/11). So I want the output to be: [CODE]11/11 11/12 //excludes Sunday 11/14 11/15[/CODE] etc. Does anyone know how to do this? Thanks

Member Avatar for Adriano_1
0
4K
Member Avatar for AntonyRayan

Hi, here I included my code to find no of working days between two years. But in leap year I do not know how to find the working days. Can anyone help me? function calculate($month,$year) { $Start_Date="1/".$month."/".$year.""; $myTime = strtotime($Start_Date); // Use whatever date format you want $daysInMonth = cal_days_in_month(CAL_GREGORIAN, …

Member Avatar for diafol
0
351
Member Avatar for ekseks

Hi Guys, I am currently making a site again for a follow-up but now it needs date! I am currently testing it on a simple html, I found this simple code on the internet but as you can see for my title I need to like sort of "autoformat while …

Member Avatar for JonyGreen
0
3K
Member Avatar for OtepTheThird

Hi Php'ers, I'm new to Php. I have some issues INSERTING date to MySQL by PHP. here's my code snippet: //date format $date1 = mysqli_real_escape_string($_POST['j_avail']); $d1 = date('Y-m-d',($date1)); $date2 = mysqli_real_escape_string($_POST['j_expir']); $d2 = date('Y-m-d',($date2)); the query: $sql = "INSERT INTO table (....,j_avail,j_expir) VALUES (....,'$d1','$d2')"; the HTML: <td id="ititle">Availability :</td> <td><input …

Member Avatar for Hilal2009
0
11K
Member Avatar for crazyvonzipper

Hi al you wonderful daniweb peoplez :) I am currently on a mission to write some cool javascript / jquery / ajax controls and now i realised that if I call the control multiple times it seems to lose scope. I realise that this is a small design flaw, and …

0
239
Member Avatar for davy_yg

How to change the format of: --> var enterDate = '2016-01-15'; // to 2016-01-15T00:00:00.0000000+08:00 with JS syntax? // I try these and none of these works out: 1) enterDate.format("yyyy-mm-ddT00:00:00.0000000+08:00"); console.log(enterDate); 2) enterDate.toLocaleFormat("%B %e, %Y %M:%S"); Thanks in advance.

Member Avatar for diafol
0
371
Member Avatar for vegaseat

Some folks go on vacation around the Easter holidays, so it would be nice to know when Easter happens in the years ahead. I had this as a Python snippet in my "oldies, but goodies" file and translated it to Go. It was actually quite easy in this case, and …

Member Avatar for vegaseat
0
938
Member Avatar for olegb

SQL Gurus, help !! I have a table with 3 fields, ID, Answer_5, Answer_6. Answer_5 & Answer_6 both hold a date value, but the fields are defined as string (for other reasons). In Answer_6 it is possible to have the string of 'Now'. I am trying to do a simple …

Member Avatar for AleMonteiro
0
350
Member Avatar for Joemeister

I want to know how to achieve the following: I want to convert a varchar to a date format but so far I'm not very successfull... My date (varchar) looks something like this: 02-02-2012 11:48 AM And I want to convert it to the following this: dd-mm-yyyy To be able …

Member Avatar for Joemeister
0
288
Member Avatar for Niloofar24

Hi friends. With `datetime.datetime.now()` or `datetime.datetime.today()` i can get the current date (English calendar) for my program but what about if i want to get the current date (from Persian calendar) for my program; then what should i do? As my pc os date is set to English calendar so …

Member Avatar for Niloofar24
0
326
Member Avatar for Niloofar24

Hello friends. I want to create a countdown program for the new year that is comming. I know i can use this code for example, for short certain time: from threading import Timer def sayhi(): print "hello everybody!" t = Timer(10, sayhi) t.start() But the new year begins in 29 …

Member Avatar for Niloofar24
0
810
Member Avatar for luma64

Hello, I call php from js file with parameter date. Date has other format when it run in IE and Mozzila. Whats problem ? IE : Tue Jun 18 19:00:00 UTC 0200 2013 Mozille : Thu Jun 20 2013 18:30:00 GMT 0200 (Central Europe Standard Time)

Member Avatar for diafol
0
211
Member Avatar for Szabi Zsoldos

Hey guys, I have this script that does count one year of files, 2014, but when it comes to this year, everything messes up. How could I count properly for each year in the same script ? In the attached screenshot it's obvious that I would only need 2014 - …

Member Avatar for Watael
0
1K
Member Avatar for OtepTheThird

Hi Guys, Im currently working with application, where it will automatically inform the user that there is an overdue account today. i decided to compare the current date(today) to stored date in mysql database, heres my code: Public Sub getReminder() Dim _con1 As New MySqlConnection Dim _cmd1 As New MySqlCommand …

Member Avatar for Santanu.Das
0
3K
Member Avatar for ddanbe

OK I know the DateTime structure is very good at doing this. But if you ever wanted to design your own calendar, or just wanted to know how things are possibly done, this could be a handy function. Enjoy.

Member Avatar for xrjf
0
2K
Member Avatar for ogsirus

Hi guys, I have a number of files within a directory which are named Log-2014-01-21.txt and similar. What I’m trying to do is write a program that will archive these files based on the month that is in the file name rather than the file Info. The part I’m struggling …

Member Avatar for deceptikon
0
1K
Member Avatar for strikeymate

Hi, had a date/boot problem for a long time and What was happening is this: At first the computer refused to boot at all... pure black screen no writing, so knowing my battery was propbably flat, I would leave it on for a minute or so, reboot again, and contrary …

Member Avatar for Slavi
0
321

The End.